Tuesday, March 18, 2008

SQL Query Script Used to List out All User Table Name of a Database

To List out all user table name of a database, just using the query statement as below:

SELECT Table_Name
FROM INFORMATION_SCHEMA.Tables
WHERE Table_Type = 'BASE TABLE'

0 comments: