1. Home
  2. Cloud & Dedicated Servers
  3. MS SQL
  4. How do I List All Database Objects?

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:

EXEC sp_tables

This will output all the objects in your database.

Content retrieved from: https://support.appliedi.net/kb/a285/how-do-i-list-all-database-objects.aspx.

Updated on November 11, 2019

Was this article helpful?

Related Articles

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!