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

You are here: irt.org | FAQ | ColdFusion | Q3006 [ previous next ]

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>

©2018 Martin Webb