Delete rows from two tables

[bharadwajrv]

Hi there:

i have a <master> table and a <transaction> table... When a record is deleted from <master> table, i need to make sure that, the associated records in <transaction> table is deleted... Can i do it in a single sql statement or should it be a separate 'delete' statement...

thanks for your help..
cheers
Venu

[r035198x]

Hi there:

i have a <master> table and a <transaction> table... When a record is deleted from <master> table, i need to make sure that, the associated records in <transaction> table is deleted... Can i do it in a single sql statement or should it be a separate 'delete' statement...

thanks for your help..
cheers
Venu

Sounds like a job for a trigger on the master table to me.

[bharadwajrv]

Sounds like a job for a trigger on the master table to me.

i cant use trigger for this due to project constraints... is it possible to have a SQL script to do this...??

[r035198x]

i cant use trigger for this due to project constraints... is it possible to have a SQL script to do this...??

Yep you can. Just make them seperate statements running one after the other.

[FritzLeblanc]

You could also use referential integrity specifying cascade delete.

[r035198x]

You could also use referential integrity specifying cascade delete.

I would prefer this method. It's always best to make the DB take care of these things because the DB usually has a longer memory than ours.