how to display all the table name in database : 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



This Transact SQL will list that information:

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

Hope this helps,


-- Anonymous, July 13, 2004

Moderation questions? read the FAQ