Table info from ADO Connection

Is there any way to attain the names of the tables in a database from using
either ADO connection or ODBC or any other type of connection.

The reason I wish to do this is so that I can display all the information in
table (field names and values - this piece of code works) from a dynamic
SQL statement

Here is what I am trying to do:
<%
Connect to my_table.
%>

<select>
<%
For each Table in My_table

response.write "option value='" & table.name& "'>" & table.name & "</option>

Next

%>
</select>

Is this possible???

Regards,

Stuart

Bob
Mon Sep 01 09:40:17 CDT 2003

Yes, it's possible. You can use the OpenSchema method with the
adSchemaTables (20) argument to retrieve a recordset containing the names of
the tables in your database.

If you don't have ADO online help, you can get more details about this
method here:
http://msdn.microsoft.com/library/en-us/ado270/htm/mdamth03_4.asp

HTH,
Bob Barrows

Stuart wrote:
> Is there any way to attain the names of the tables in a database from
> using either ADO connection or ODBC or any other type of connection.
>
> The reason I wish to do this is so that I can display all the
> information in table (field names and values - this piece of code
> works) from a dynamic SQL statement
>
> Here is what I am trying to do:
> <%
> Connect to my_table.
> %>
>
> <select>
> <%
> For each Table in My_table
>
> response.write "option value='" & table.name& "'>" & table.name &
> "</option>
>
> Next
>
> %>
> </select>
>
> Is this possible???
>
> Regards,
>
> Stuart