Table info from ADO Connection

S

Stuart

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
474,085
Messages
2,570,597
Members
47,218
Latest member
GracieDebo

Latest Threads

Top