Originally posted by n_sateesh
Is there any way to delete data in more than one table using a single DELETE statement.
Actually my req. is deleting rows in all the child tables based a criteria. I know I could do it with multiple DELETE calls, but I am just looking for any better way of doing it.
There is a way where you can create a view on the table with check option aand you can create a trigger kind "INSTEAD OF" and through that way you can carry out deletes in several tables with only one sentence.