July 25, 2001 at 2:47 pm
What built-in stored procedure would display all user tables in a database?
Can someone give me advice on that?
Regards-Grace copy me please gbarr@czn.com
July 25, 2001 at 5:29 pm
There is a view and table you can use.
For all tables (and views) you as a user has access to:
SELECT * FROM INFORMATION_SCHEMA.Tables
For all user table:
SELECT [name] FROM sysobjects WHERE type = 'U'
The last will pick up dtproperties (database diagrams) and MS replication tables, but you can filter those out with the appropriate WHERE clauses if need be.
K. Brian Kelley
K. Brian Kelley
@kbriankelley
July 25, 2001 at 7:06 pm
Both are good solutions. Had never thought about it, but was surprised there was no sp_helptable type sp.
Another way to get the list from an existing stored procedure would be to run this:
sp_msforeachtable 'print ''?'''
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply