Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Apr 7, 1999

Retrieving database table names using SQL

Question:
I'm a database administrator for a medium-sized company. I would like to be able to retrieve the names of the tables within the company's database using SQL so that I could do some administration remotely. Is there a way to do so? I believe that there is a system table that can be accessed using SELECT to provide this service, but I am not sure of its name.

Answer:
You can use the stored procedure sp_tables to obtain a list of tables.

You can also execute:


select * from sysobjects where type = 'U'
to obtain the user created tables.

Last, if you have version 7, you can also do a select from INFORMATION_SCHEMA.TABLES

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date