SQL Server delete data with Linked Table ?

Question

Suppose you have 3 tables: TABHDBH TABHDBHCHUYEN and TABHDBHCT Table TABHDBH has the following fields: NGAY DateTime; IDHDBH int ... Table IDHDBHCT has the following fields: MAHDBH int ... TABHDBHCHUYEN NGAYCHUYEN datetime MAHDBH int ... RELATIONSHIP OF 3 TABLE TABHDBHCHUYEN.MAHDBH head n TABHDBH.IDHDBH head 1 TABHDBHCT.MAHDBH head n DELETE T1 FROM TABHDBHCHUYEN T1 INNER JOIN TABHDBH T2 ON T1.MAHDBH = T2.IDHDBH INNER JOIN TABHDBHCT T3 ON T2.IDHDBH = T3.MAHDBH WHERE ( CONVERT ( VARCHAR  NGAYCHUYEN 101) '01/07/2017' ) When running the query without error only delete the 1 record in TABHDBHCHUYEN and the records in the other 2 TABLE not delete record you see help me wrong? Created a relational table for 3 tables to Delete Rule mode to Cascade but not delete.

Nilesh Shah · Answer

in your delete query you have statement DELETE T1 from... hence it is going to delete only the records of T1 i.e. TABHDBHCHUYEN records of 2 other tables will not be deleted. either you need to explicitly delete them or write after delete trigger on TABHDBHCHUYEN or define your foreign keys with on delete cascade statement

Dong Lam Trien · Answer

In relationship. I got into the INSERT AND UPDATE Specification of the foreign key that set Delete Rule to Cascade but it still does not delete.