view all tables 1

[camy123]

hi quick question whats the sp to display all tables in the database

i normally type

use database
sp_help

but thisshows all objects any idea.

or is there a table in the master database i can query.

 

[jby1]

To see all user tables in a database, use the following within the database you want the information for:

select *
from sysobjects
where type='U'

 

[mrdenny]

Be carefull using system tables. They can change from version to version of SQL Server. When quering the system tables you should use the INFORMATION_SCHEMA views instead. These are not supose to change from version to version, and 90% of data you will want from the system tables is available throught these views.

select  * 
from information_schema.tables 
where table_type = 'BASE TABLE'

Denny

--Anything is possible. All it takes is a little research. (Me)