Getting table field names

[Eidolon]

Is there any way in Access that i can get a listing of the field names in a
table via SQL, not ADO code?
I am looking for something similar to the following SQL statement in ORACLE:

SELECT
COLUMN_NAME
FROM
USER_TAB_COLUMNS
WHERE
TABLE_NAME = 'CATALOG';

Thanks in advance.
- Aaron.

 

[Van T. Dinh]

Not in JET SQL, AFAIK.

You can use the VBA code with the DAO TableDef Object to retrieve the Field
Names.