p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   MySQL (http://p2p.wrox.com/forumdisplay.php?f=99)
-   -   List tablesname from database & list databasename (http://p2p.wrox.com/showthread.php?t=6242)

ittorget November 17th, 2003 06:58 AM

List tablesname from database & list databasename
 
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'



All times are GMT -4. The time now is 12:57 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.