SQL Server - Catalog Queries 2005/2008

Produce List of SQL Server Tables

The following query will produce a list of user tables for a given SQL Server 2005/2008 database.

Query

 
select 
  all_objects.name as 'Tables',
  all_objects.object_id as 'object_id',
  all_objects.create_date as 'create_date',
  all_objects.modify_date as 'modify_date' 
from sys.all_objects
where type = 'U'

 Collapse All    Expand All

• SQL Server 2005/2008
  • List User Tables
  • Create Table Info
  • Prikey/Index Info
  • List FK Contraints
  • List Check Constraints
  • List Default Contstraints

SQL Server Information and Resources