| SQL Query to disable or unable foreign key constraints temporarily by using TSQL?
There are certain conditions when we disable or unable foreign key or any other constraints on any table. After doing our operations just rollback the contraints on any of the SQL table:-
(1)Query to disable all table constraints
ALTER TABLE table_name NOCHECK CONSTRAINT ALL
(2)Query to enable all table constraints
ALTER TABLE table_name WITH CHECK CHECK CONSTRAINT ALL
(3)Query to disable single constraint
ALTER TABLE table_name NOCHECK CONSTRAINT constraint_name
(4)Query to enable single constraint
ALTER TABLE table_name WITH CHECK CHECK CONSTRAINT constraint_name | | |