Skip to content
DBCode

NOCHECK

Example

Section titled “Example”
ALTER TABLE SalesOrderDetail NOCHECK CONSTRAINT FK_SalesOrderDetail_Product_ProductID

Output

Section titled “Output”
Command(s) completed successfully.

Explanation

Section titled “Explanation”

The above SQL command disables the foreign key constraint named FK_SalesOrderDetail_Product_ProductID on the SalesOrderDetail table. Any INSERT, UPDATE, or DELETE operations will not check this constraint until it is enabled again. This can be used to improve performance for bulk operations. After operations complete, it is advised to enable the constraint using the CHECK CONSTRAINT command.