摘要: --删除所有外键约束DECLARE c1 cursor forselect 'alter table ['+ object_name(parent_obj) + '] drop constraint ['+name+']; 'from sysobjectswhere xtype = 'F'open c1declare @c1 varchar(8000)fetch next from c1 into @c1while(@@fetch_status=0)beginexec(@c1)fetch next from c1 into @c1 阅读全文
posted @ 2012-02-16 17:11 偶不是大叔 阅读(1903) 评论(0) 推荐(0) 编辑