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.
Content retrieved from: https://support.appliedi.net/kb/a285/how-do-i-list-all-database-objects.aspx.