Getting table field names

  • Thread starter Thread starter Eidolon
  • Start date Start date
E

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.
 
Not in JET SQL, AFAIK.

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