Our Training Programs

All contents are copyright of their authors.

Delete all child tables record when master table record del.

Delete all child tables record when master table record del.

Sonu Gupta

7yAsked Aug 1, 2019, 7:47 AM1.2kSQL

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

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Dipa Mehta7y ago
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/
Amit Mohanty7y ago
Hey check the below link.

https://www.c-sharpcorner.com/article/cascading-referential-integrity/
Jaish Mathews7y ago
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 Maurya7y ago
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