READING ALL THE CREATED TABLES FROM A DATABASE

Results 1 to 2 of 2

Thread: READING ALL THE CREATED TABLES FROM A DATABASE

  1. #1
    Join Date
    Dec 1969
    Posts
    34

    Default READING ALL THE CREATED TABLES FROM A DATABASE

    I WANT TO SHOW ALL THE CREATED TABLES FROM A GIVEN DATABASE.<BR>FOR THIS I TRIED WITH CREATING AN OBJECT FROM SQLOLE.SQLSERVER.<BR>BUT THAT OBJECT SHOWS ME AS EMPTY.<BR>HOW DO I SOLVE IT.

  2. #2
    Nathen Grass Guest

    Default RE: READING ALL THE CREATED TABLES FROM A DATABASE

    You can use the OpenSchema method of the Connection object.<BR>For example:<BR><BR>&#060;%<BR>&#039Open you connection<BR>Set objRSTbls = objConn.OpenSchema(adSchemaTables)<BR>Do while not objRSTbls.EOF<BR>&nbsp;&nbsp;&nbsp;Response.Write( objRSTbls("TABLE_NAME") & "&lt;BR&gt;")<BR>Loop<BR>%&#062;

Posting Permissions

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