Posted by MC on 01/23/07 15:16

Something like this?

select *
from northwind.information_schema.tables


MC


<plmanikandan@gmail.com> wrote in message
news:1169564583.684348.195860@l53g2000cwa.googlegroups.com...
> Hi,
> I need to list all the tables in northwind database.
> I'm using sql server 2000.
> In query analyser i'm in master database.
> I don't want to change the database to northwind.
> How to list all the tables in northwind database when the database
> combobox has master in query analyser.
> I want to run this query with database name.I won't want to run for
> current database.
> Kindly help me to solve the problem.
>
> Thanks & Regards,
> Mani
>

[Back to original message]