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'
Tuesday, March 18, 2008
SQL Query Script Used to List out All User Table Name of a Database
Posted by Wec at 2:31:00 PM
Labels: SQL Server
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment