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