deleting a single record from multiple tables

Hi All
i have a common field say email in 5 tables.
i want to delete a single record which should be deleted from all the table from which the email is related.
can anybody suggest me for the same.
Thanks

You should run 5 separate Delete statements, all within a transaction (so either they will all be deleted, or none of them will be).

Exactly how you do this depends on a few factors, such as what database system you are using, and where you want to run this from.

I m using sql server2000 as an backend. and ASP front end.
I want to make a function and want to call it in asp page.
in this function i need to write delete command .

Quote:

---

Originally Posted by si_the_geek

You should run 5 separate Delete statements, all within a transaction (so either they will all be deleted, or none of them will be).

Exactly how you do this depends on a few factors, such as what database system you are using, and where you want to run this from.

---