How to get Field Name and Field Size for a Table

[LyndonOHRC]

I'm using the following query to get the list of table names from a database:

SELECT Name
FROM MSysObjects
WHERE Type=1 AND Flags=0

Is there a way to run a query on one of these table names to get it's field names and their sizes?

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[dhookom]

Field information is not stored in system tables where you can easily get at it with a query/sql. You would need to use the Documenter or another utility or code to get this information.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]