alter table mylocation
drop constraint fk_mylocation_myname
alter table mylocation
add constraint fk_mylocation_myname foreign key(myname)references myname(name)
on update cascade on delete cascade
drop constraint fk_mylocation_myname
alter table mylocation
add constraint fk_mylocation_myname foreign key(myname)references myname(name)
on update cascade on delete cascade
CONSTRAINT 名 FOREIGN KEY
(
字段名
) REFERENCES 另一表名 (
字段名
) ON DELETE CASCADE ON UPDATE CASCADE
GO
drop constraint fk_mylocation_myname
alter table mylocation
add constraint fk_mylocation_myname foreign key(myname)references myname(name)
on update cascade on delete cascade
就象sql server的企业管理器就有可视化的关系管理器阿,只要打大勾就行了,是不是是他的处理过程也是先drop再add的阿?