MS SQL Server - Delete records from several tables at once

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Delete records from several tables at once

JotaO

2006-03-26, 7:25 am

Hi!

Is there any SQL command that allow me to delete records from a list of
tables?

Something like this: "Delete From Table1, Table2"

TIA

Jorge

David Portas

2006-03-26, 7:25 am

JotaO wrote:
> Hi!
>
> Is there any SQL command that allow me to delete records from a list of
> tables?
>
> Something like this: "Delete From Table1, Table2"
>
> TIA
>
> Jorge

Answered in microsoft.public.sqlserver.programming

Please do not multi-post!

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Sponsored Links