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
Custom Search

SQL Server Information and Resources