Thread: List tablesname from database & list databasename
View Single Post
  #2 (permalink)  
Old November 17th, 2003, 10:51 PM
happygv happygv is offline
Friend of Wrox
  
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default
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
Reply With Quote