SQLServer删除所有外键

概述declare @sql varchar(max), @tab_name varchar(128), @fk_name varchar(128);declare c cursor forselect OBJECT_NAME(parent_object_id), name from sys.objects where type='F'open cfetch next from c in

declare @sql varchar(max),@tab_name varchar(128),@fk_name varchar(128);declare c cursor forselect OBJECT_name(parent_object_ID),name from sys.objects where type='F'open cfetch next from c into @tab_name,@fk_name while @@FETCH_STATUS=0begin  set @sql=''; set @sql='alter table ' + @tab_name + ' drop constraint ' + @fk_name print @sql exec(@sql)  fetch next from c into @tab_name,@fk_nameendclose cdeallocate c

总结

以上是内存溢出为你收集整理的SQLServer删除所有外键全部内容，希望文章能够帮你解决SQLServer删除所有外键所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。