when bulk of loading is to be needed these type of constraint are foreign and check constraint.
-- Disable the constraint
ALTER TABLE [table name]
NOCHECK CONSTRAINT CK_aamir_hasan
-- Enable the constraint
ALTER TABLE [table name]
WITH CHECK CHECK CONSTRAINT CK_aamir_hasan
posted by Aamir Hasan
Author:
Aamir Hasan औथोर:
आमिर हसन أثر
أمير حسن .
7226f6f2-a0b4-4202-b51c-f5e0aeb29e13|0|.0
ALL, Functions, Constraint