devxlogo

Retrieving database table names using SQL

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-admin

Share the Post: