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

Answers

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