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