View Db objects with recordset

[duckweb]

Ok...i have seen this somewhere before, but forgot how to do it...I need to use ASP to view all table names in a given database...I know there is some SQL that allows this.

Any ideas?

 

[NoCoolHandle]

It would help alot if you said what type of database you are working with. THey all tend to be different

If you were working with SQL Server it is the database.dbo.sysobjects table where type = 'u'

with access you query the database object...

It is all different

Rob

 

[palbano]

Your question should be asked in the forum for the specific database. Click the "Forum List" link in the top left corner of the site and find your database in the list.

-pete

 

[WindUp]

>I need to use ASP to view all table names in a given database.

   dim aaTables
   dim adoxconn
   dim x
   dim y

   set adoxconn = server.createobject("ADOX.Catalog")
   adoxconn.activeconnection = conn

   '*** The Following is for Debugging ONLY!!! ***
   for each x in adoxconn.tables
      if(x.type="TABLE")then
         response.write(&quot;<hr><p><b><u>&quot; & x.name & &quot;</u></b></p>&quot;)
         for each y in x.columns
            response.write(&quot;<p><b>&quot; & y.name & &quot;</b> Type=&quot; & y.type & &quot; size=&quot; & y.definedsize & &quot;</p>&quot;)
         next
      end if
   next

   set adoxconn = Nothing

Good Luck!
WindUp