list all tables in master

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,
ManiSomething like this?

select *
from northwind.information_schema.tables

MC

<plmanikandan@.gmail.comwrote in message
news:1169564583.684348.195860@.l53g2000cwa.googlegr oups.com...

Quote:

Originally Posted by

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
>