Does MS Access have a Show Columns SQL command

[UpstateWeb]

I have recently discovered how to Alter Add and Drop columns from MS Access.
This is going to help me a lot with updating multiple databases when I make
changes to my administrative product. Before I was opening each database and
making the changes. Yuck...

What I am running into is some of the tables don't have data in them yet and
so I can't query against them to get a columnlist. Is there a way to get this
with MS Access 2003 on MX 6.? Something like:

<cfquery name="getColumnList" datasource = "#DSN#">
SHOW Columns from Tablename
</cfquery>
<cfoutput>#getColumnList.Columnlist#</cfoutput>

Thanks in advance,

Rock Moore

P.S. And thanks to so many who have helped me over the last 2 weeks. I have
had a time of it upgrading from 4.5 to 6.1. I did not test and plan enough...

[philh]

SELECT * from MSysobjects
WHERE Type = 1
AND left([name],4) <> 'MSys'

Provided, of course, that you can get the permission to query the MSysObjects table.