摘要:
1.删除所有外键DECLARE c1 cursorfor select'alter table ['+object_name(parent_obj) +'] drop constraint ['+name+']; ' from sysobjects where xtype ='F'open c1declare@c1varchar(8000)fetchnextfrom c1 into@c1while(@@fetch_status=0) begin exec(@c1) fetchnextfrom c1 into@c1 endclose 阅读全文