Q3006 How do I get a list of tables contained in my Microsoft Access database?

irt.org | Knowledge Base | ColdFusion | Q3006 [ previous next ]

Q3006 How do I get a list of tables contained in my Microsoft Access database?

Actually, you can do this with some simple SQL. The following query returns an alphabetically-sorted list of tables contained in your Microsoft Access database.

<cfquery datasource="myDatasource" name="GetTables">
SELECT MSysObjects.Name FROM MSysObjects
WHERE (((MSysObjects.Flags)=0) AND ((MSysObjects.Type)=1))
ORDER BY MSysObjects.Name
</cfquery>

Feedback on 'Q3006 How do I get a list of tables contained in my Microsoft Access database?'

• October 16, 2001 at 22:40:34: THIS EXAMPLE DOES NOT WORK
• 22:55:41 9/26/00 Matt Fisher
• 06:36:13 7/05/00 shankar
• 11:48:28 5/04/00 Orlando Correa