sql 代码
- 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