1、单表语句
--禁止表的单个约束
ALTER TABLE table_name NOCHECK CONSTRAINT constraint_name ;
--禁止表的所有约束
ALTER TABLE table_name NOCHECK CONSTRAINT ALL ;
--启用表的单个约束
ALTER TABLE table_name CHECK CONSTRAINT constraint_name ;
ALTER TABLE table_name CHECK CONSTRAINT constraint_name ;
--启用表的所有约束
ALTER TABLE table_name CHECK CONSTRAINT ALL;
2、生成某库所有表的约束脚本语句
select * from t1;
select * from t2;
--禁止表的所有约束
select 'ALTER TABLE '+ table_name +' NOCHECK CONSTRAINT ALL ;' from INFORMATION_SCHEMA.TABLES;
select 'ALTER TABLE '+ table_name +' NOCHECK CONSTRAINT ALL ;' from INFORMATION_SCHEMA.TABLES;
--启用表的所有约束
select 'ALTER TABLE '+ table_name +' CHECK CONSTRAINT ALL ;' from INFORMATION_SCHEMA.TABLES;