List Tables In Database

Results 1 to 2 of 2

Thread: List Tables In Database

  1. #1
    Kevin Guest

    Default List Tables In Database

    I am trying to find the syntax to list all the tables in my database. I know I&#039ve seen it before but I can&#039t find it now that I need it. Can someone advise how to do this. Thanks in advance.

  2. #2
    gh Guest

    Default RE: List Tables In Database

    ADODB.Connection.OpenSchema() returns a recordset of the tables in the database.<BR><BR>...<BR> Set oRS = oConn.OpenSchema(adSchemaTables) &<BR> <BR> Do Until oRS.EOF<BR>&nbsp┬*┬* Response.Write "Table name: " & _<BR>&nbsp┬*┬*┬*┬* oRS("TABLE_NAME") & _<BR>&nbsp&nbsp┬*┬*┬*┬*┬*┬* " Table type: " & oRS("TABLE_TYPE") & "&ltbr&gt"<BR>&nbsp┬*┬*┬* oRS.MoveNext<BR> Loop<BR> oRS.Close<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