List tablesname from database & list databasename

ittorget · November 17th, 2003, 06:58 AM

I need to found out how to get a return statement of tables(name) from a database.

Database1
  table1
  table2

Database2
  table1

I need to return both database and the tables from that database !

happygv · November 17th, 2003, 10:51 PM

You can use SHOW DATABASES to get the list of databases in the server.

And use SHOW TABLES to list the tables in a given database.

Hope that helps.

Cheers!

-Vijay G

abhisheksud · September 5th, 2005, 05:43 AM

Could you please tell the full code....

sriram6781 · September 10th, 2005, 03:06 AM

You can query sysobjects if you are using SQL Server and search for XTYPE='U'