Query SysObjects

select * from sysobjects
- returns all Objects in a database (e.g. tables, Views, Stored Procedures)


select * from sysobjects where type = 'U'
- returns all Tables Objects


select * from sysobjects where type = 'V'
- returns all SQL Views Objects


select * from sysobjects where type = 'P'
- returns all SQL Stored Procedure Objects