Is there a way to retrieve the table names from a database using MySql and VBScript(ASP Page)?



For example:



I would use the conn method to connect to the database:



  Set conn = Server.CreateObject("ADODB.Connection")

  conn.open= "driver={MySQL ODBC 3.51 Driver};server=localhost;uid=myId;pwd=myPwd;databa se=myDb;Option=16387;"



I don't know the properties to get the names of the tables in the database.



Something like(I'm guessing)

For Each Table in myDB

  Response.Write "<br>" & Table.Name & "<br>"

Next



I've tried to do some searching for the answer, thanks in advance for your help.

You can query the database for a list of tables.

http://dev.mysql.com/doc/mysql/en/SHOW_TABLES.html

Take care,

Nik
http://www.bigaction.org/