SQLServer关闭及开启所有约束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
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'ALTER TABLE ? DISABLE TRIGGER ALL'
EXEC sp_MSForEachTable 'DELETE FROM ?'
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'ALTER TABLE ? ENABLE TRIGGER ALL'
EXEC sp_MSFOREACHTABLE 'SELECT * FROM ?'