Thursday, March 22, 2007

Cry How To - List all tables

Cry How To - List all tables: "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'"

No comments: