摘要: 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 阅读全文
posted @ 2014-03-31 10:52 dodo-yufan 阅读(531) 评论(0) 推荐(0) 编辑