how to display all the table name in database

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

hi all, i want to display all the tables in the Database in Ms Sqlserver.

-- Anonymous, July 13, 2004

Answers

Rajkumar,

This Transact SQL will list that information:

select name from sysobjects where xtype in ('S', 'U')

Hope this helps,

Eric

-- Anonymous, July 13, 2004


Moderation questions? read the FAQ