--获得禁用所有外键约束的语句
select 'ALTER TABLE [' + b.name + '] NOCHECK CONSTRAINT ' + a.name +';' as 禁用约束
from sysobjects a ,sysobjects b
where a.xtype ='f' and a.parent_obj = b.id
--获得启用所有外键约束的语句
select 'ALTER TABLE [' + b.name + '] CHECK CONSTRAINT ' + a.name +';' as 启用约束
from sysobjects a ,sysobjects b
where a.xtype ='f' and a.parent_obj = b.id
[代码] SQL Server禁止全部约束应用到数据表
1 | ALTERTABLEtb1 |
2 | NOCHECK CONSTRAINTALL |
3 | GO |
[代码] SQL Server解禁全部约束应用到数据表
1 | ALTERTABLEtb1 |
2 | CHECKCONSTRAINTALL |
3 | GO SQL约束控制
SQL 禁用开启表的所有约束 2000
--禁用所有约束
exec sp_msforeachtable "alter table ? nocheck CONSTRAINT all" --再启用所有外键约束 exec sp_msforeachtable "alter table ? check constraint all" 2005 EXEC dbo.sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL' |