How to delete data with foreign KEY constraints

SQL Server 2012

Table TableA and Tbaleb have foreign KEY constraints, the constraint column named Tbaleb itableaid column, the deletion will prompt

DELETE dbo. TableA

MSG 547, Level 16, State 0, line 1th

The DELETE statement conflicts with the REFERENCE constraint "Fk_tbaleb_tablea_itableaid". The conflict occurred in the database "TEST", table "dbo." Tbaleb ", column ' Itableaid '.

Statement has been terminated.

At this point, you need to disable the tbaleb corresponding to the constraint

Need to perform

ALTER TABLE dbo. Tbaleb NOCHECK CONSTRAINT All

At this point Tbaleb and TableA no longer check constraints

and then

DELETE dbo. TableA

Finally, you need to restore the constraint

ALTER TABLE dbo. Tbaleb CHECK CONSTRAINT All

Alter change

Check Checks

CONSTRAINT constraints

How to delete data with foreign KEY constraints