Re: ASP/SQL: How do I get a list of tables in the database (what is good reference source)

Hi Jake!

The closest I could get is:

         select name
          from MSysObjects
         where type in (1, 4)

which will return you the names of the physical tables and any linked 
tables in the database.

Hope this helps,
Eric

At 03:37 AM 9/29/2000 -0400, Jake wrote:
>This may sound basic, but I'm having trouble locating a good reference
>source for my ASP site development.
>
>I'm using ASP(VBScript) to quire an Access database.  What I need to know
>at this point is:
>
>How to generate a list of the tables available in a database file?
>More to the point the SQL or SELECT statement do find out what the table
>names are, I pretty much know how to deal with the rest.  In ORACLE I
>recall something like SELECT * FROM DUEL;
>
>If there is a good quick reference (net or book) that will list commands
>and parameters for such things as SQL(for Access and or MySQL), VBS, ASP,
>JScript I would be forever greatful for such information.

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA