list all tables in master

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • plmanikandan@gmail.com
    #1

    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,
    Mani

    Tags: None
    • MC
      #2
      Re: list all tables in master

      Something like this?

      select *
      from northwind.infor mation_schema.t ables


      MC


      <plmanikandan@g mail.comwrote in message
      news:1169564583 .684348.195860@ l53g2000cwa.goo glegroups.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
      >

        Comment

        Previous template Next
        Working...