Delete all child tables record when master table record del.

Question

How to delete all child tables record when master table records deleted, in sql? Please explain the how many ways to do it.

Jaish Mathews · Answer

I am not sure why need separate SQL for it. For SQL Server, correct solution is use foreign key as on-delete-cascade during design itself and then database will take care of it.

Aakash Maurya · Answer

If you want to do this in SQL itself then you have to create a Trigger. You can fire trigger on Delete of Parent TABLE. http://www.4guysfromrolla.com/webtech/sqlguru/q061400-1.shtml https://medium.com/@lukassinkus/sql-server-combination-of-cascade-deletes-and-triggers-might-not-work-in-the-order-you-expect-them-79f16f061aa8 Let me know if any additional help is need

Amit Mohanty · Answer

Hey check the below link. https://www.c-sharpcorner.com/article/cascading-referential-integrity/

Dipa Mehta · Answer

There are generally two scenarios when deleting data from tables with FKs, one is to delete all of the data and the other is to delete a few records. More details refer this link: https://www.mssqltips.com/sqlservertip/4059/script-to-delete-data-from-sql-server-tables-with-foreign-key-constraints/

Delete all child tables record when master table record del.

Answers (4)