Browse DevX
Sign up for e-mail newsletters from DevX

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



Building the Right Environment to Support AI, Machine Learning and Deep Learning

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