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 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