List All the Tables in a SQL Server Database

back

Description

Displays all of the tables in a given SQL Server DB.

Supported Platforms SQL Server 2000

Script Code

SELECT TABLE_SCHEMA,TABLE_NAME, OBJECTPROPERTY(object_id(TABLE_NAME), N'IsUserTable') AS type 
 FROM INFORMATION_SCHEMA.TABLES
Backback