è¦ä¿®æ¹ä¸»é®åå¤é®çè¯éè¦å
æå®ä¸»é®åå¤é®çå称ï¼ä»¥åä¿®æ¹æ¶è¦ç¨å°ã
è¿æ¯ç主é®åå¤é®è®¾ç½®æ¥éª¤ï¼
ä¿®æ¹çsqlè¯å¥ï¼
--ä¿®æ¹ä¸»é®çå称PK_myTest为PK_myTest22
alter table myTest drop constraint PK_myTest
alter table myTest add constraint PK_myTest22 primary key(aa)
--ä¿®æ¹å¤é®çå称fk_myTest为fk_myTest22
alter table myTest drop constraint fk_myTest
alter table myTest add constraint fk_myTest22 foreign key(bb) references testï¼
温馨提示:答案为网友推荐,仅供参考