I have data set up like the following:
Table1:
PK ID
fields....
Table2
PK ID
FK ParentID -> is Table1 PK
Fields.....
Table3 (similar to Table2).
I want to delete a row from Table1 along with all of the related rows in Table2, Table3, etc.
What is the easiest way to do that?
Thanks