How do I List All Database Objects?

You can query the sysobjects system table or the INFORMATION_SCHEMA views by running the following stored procedure:

1
EXEC sp_tables

This will output all the objects in your database.

Add Feedback