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