Delete on Multiple Tables

Hi All
 I need to delete records on multiple tables, based on the value of one Column say.. ColID.
Do I need to delete the records from each table separately,like

Delete from TableA where ColID = 1;
Delete from TableB where ColID = 1;
Delete from TableC where ColID = 1;

Or Is there a way I can delete all the records in all the tables using one Delete Statement?

Thank's alot.
JohnP. Received on Thu Nov 10 2005 - 21:31:47 CST