Get table names

Results 1 to 2 of 2

Thread: Get table names

  1. #1
    Join Date
    Dec 1969

    Default Get table names

    After connecting to a database how can I list the table name<BR><BR>I can list the field names in a table with<BR><BR>for each field in rs.fields <BR>Response.write & "<BR><BR>next<BR><BR>But I can&#039;t get the tables names<BR>

  2. #2
    Join Date
    Dec 1969

    Default ADODB.Connection.OpenSchema

    Use that method and specify the proper arguments and what you get back is a recordset with table names (and, optionally, other info) in it!<BR><BR>Look up the docs for OpenSchema. It&#039;s really quite easy to use. <BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts