Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

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



Application Security Testing: An Integral Part of DevOps

Retrieving database table names using SQL

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.

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.



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