Home
How To ...
Trouble shooting
 

Cry How to...

List all tables


To get a list of all the tables in a SQL Server database, use either:

sp_tables

or alternately to list only the user tables use:

select name, user_name(uid) from sysobjects where type='U'


These notes have been tested against SQL Server 7 and SQL Server 2000.