Listing Fields in a Table (Access 2003/SP3)

[WebGenii]

The following statement will list all the tables in my database,
I'm looking for a variation to list all the fields in each table...

[HansV]

"The following statement" must be extremely compact... I fail to see it.

BTW have you tried Tools | Analyze | Documenter, or our own Mark Liquorman's Liquorman Utilities?

[WebGenii]

Snicker - too much multitasking


How about
SELECT MsysObjects.Name, MsysObjects.Type
FROM MsysObjects
WHERE (((MsysObjects.Type)=6))
ORDER BY MsysObjects.Name;


Documenter didn't do it for me - I'll check out Mark's utility.

[HansV]

I don't think you can use SQL to list the fields in a table. You could use DAO code to loop through the tables in the database, and to loop through the fields in each table.

[Jezza]

I am still researching this but for a SQL server it is pretty simple:

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME = 'incident')


where incident is the table name. This will just show the names of the fields not their properties