select * from tab in sql server ????

[sujitopics]

Hi

I have a doubt

in oracle we have select * from tab to show all the tables on that database.

my doubt is what is the query to show the above results in MsSqlserver 2000 i.e., to show all the tables in that database using query analizer

thanksinadvance

Yours
Suji

 

[tlbroadbent]

In the context of the database you can any of the following to display info about tables.

Select * From information_schema.tables

Select * From sysobjects
Where type='u'

exec sp_help
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[sujitopics]

Thankyou Very Much

Yours

Suji