declare @tbname varchar(250)
declare #tb cursor for select name from sysobjects where objectproperty(id,'IsUserTable')=1
open #tb
fetch next from #tb into @tbname
while @@fetch_status=0
begin
exec('alter table ['+@tbname+'] nocheck constraint all')
-- nocheck关闭所有约束 check开启所有约束
fetch next from #tb into @tbname
end
close #tb
deallocate #tb
MSSQL_关闭\打开约束
最新推荐文章于 2021-11-01 08:40:48 发布