Listing database tables

Results 1 to 2 of 2

Thread: Listing database tables

  1. #1
    Join Date
    Dec 1969

    Default Listing database tables

    Is it possible to list all the tables and their columns from a database through an asp script?

  2. #2
    Join Date
    Dec 1969

    Default RE: Listing database tables

    I&#039;ve used both the connection.OpenSchema() method and INFORMATION_SCHEMA (SQL Server) views to get this kind of information.<BR><BR>You can look through the reference at Microsoft,<BR><BR><BR><BR>It has been some time since I did this, but if I remember correctly, try something like this:<BR><BR>set rs = cn.OpenSchema(adSchemaTables)<BR><BR>and,<BR><BR>s et rs = cn.OpenSchema(adSchemaColumns,array(null,null,"myT able"))<BR><BR>It works with sqlserver 7, don&#039;t know about Access.<BR><BR>Another option would be to go to and download an application that does just that.<BR><BR>Good luck.

Posting Permissions

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