473,394 Members | 1,709 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

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

Jan 23 '07 #1
1 7232
MC
Something like this?

select *
from northwind.information_schema.tables
MC
<pl**********@gmail.comwrote in message
news:11**********************@l53g2000cwa.googlegr oups.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

Jan 23 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: red | last post by:
I'm probably crazy for even trying this but I'm trying to make a script that will iterate through my databases, iterate through all the tables, and show everything on one page in forms that allow...
1
by: Joseph Ferris | last post by:
Hello, I am having an issue with page breaking that I hope someone will be able to help me with. Still a relative "newbie", and I thought this might be a good place to find some help. I have a...
1
by: M | last post by:
In .NET (pref. c#) how does one get a list of all available SQL Servers, databases and tables. I need to allow the connection to a database, etc, on the fly. kind of like what happens in SQL Query...
11
by: Neo Geshel | last post by:
I am looking to improve redundancy in a database. If I have several different tables having identical child tables (design, not data) for holding images, is it possible to have all these...
8
by: Jason L James | last post by:
Hi all, does anyone know if I can create a dataview from multiple datatables. My dataset is constructed from four separate tables and then the relationships are added that link the tables...
3
by: jpr | last post by:
Hello, I know that this is not the rule but need some help. My datbase has three tables: MASTER TEMPLATES FORMS I have a form which is based on a table named MASTER. I have a primary key...
2
by: rich | last post by:
I am building a database and I am using a list where I can make multiple choices. The data is like this Master table item1id item2 index(item1id) detail table item1id
2
by: spcscooter via AccessMonster.com | last post by:
I have a form that I have subforms in. I have set up relationships between all tables for cascading delete so that once I delete from the main table it should delete the entry that shares the...
4
by: Cyprus106 | last post by:
Apparently, Im incapable of properly executing this query! I've been at this for far too long and gotten nowhere. Forgive me if this is a umb mistake; I'm not great at SQL. I've got three tables,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.