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.



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.


-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 05:24 PM.

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