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

See also  Redefining Energy Management: Advanced Solutions for Modern Buildings
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist