MS SQL Server - Re: Delete records from serveral 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

Re: Delete records from serveral tables at once

John Bell

2006-03-26, 7:25 am

Hi

If there is a foreign key in Table2 referencing Table1 then you can enable
cascading deletes.

John

"JotaO" <antispam@antispam.com> wrote in message
news:%23YKsGzLUGHA.1444@TK2MSFTNGP11.phx.gbl...
> 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
>
>

Sponsored Links