"Gav" <Gav@discussions.microsoft.com> wrote in message
news:2A4731B4-4D3C-4D29-BA90-88FD2905D2A8@microsoft.com...
> Hi all,
>
> Is there a way to quickly run an sql query against all the tables in a
> database? or will I have to simply write a line for each table? I have
> 100+
> tables where I want to delete rows from from them where ID= (a particular
> id).
>
> Thanks
> Gav

"Russell Fields" wrote:

> Gav,
>
> There is the undocumented stored procedure: sp_msforeachtable
>
> It will execute the command specified for the databases on your server. It
> is fairly flexible, but (as mentioned) is undocumented and therefore
> unsupported. You can also look at the code to see how it is doing the work
> and then imitate that in your own code.
>
> RLF
>
> "Gav" <Gav@discussions.microsoft.com> wrote in message
> news:2A4731B4-4D3C-4D29-BA90-88FD2905D2A8@microsoft.com...
> > Hi all,
> >
> > Is there a way to quickly run an sql query against all the tables in a
> > database? or will I have to simply write a line for each table? I have
> > 100+
> > tables where I want to delete rows from from them where ID= (a particular
> > id).
> >
> > Thanks
> > Gav
>
>