Regarding tables listing in ISQLgreenspun.com : LUSENET : SQL Server Database Administration : One Thread |
How to list all the tables that are present in the databse using the isql query???how to list all the databases that are present???
-- Anonymous, November 02, 2004
Arul,To list the user tables in a database, you can use this query:
select name from sysobjects where xtype = 'U'
To list the databases, you can use this query:
select name from master..sysdatabases
Hope this helps,
Eric
-- Anonymous, November 02, 2004