Please refer Referential integrity checking for more details.
If a user wants to remove referential integrity checking to facilitate faster
loading of test data, the following database script can be used to remove the
foreign key constraints on the References
table.
ALTER TABLE Reference DROP CONSTRAINT FK_Reference_ReferencedAlias
Note
The other foreign key constraints on the tables do not affect the referential integrity checking, so there is no need to remove them for this purpose.