Data store table properties

[Guest]

How do I print the properties (data store) of the tables in my database.

 

[Allen Browne]

If you just want a list of the tables, try this query:

SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY MsysObjects.Name;

Include type 6 for linked tables, and 4 for ODBC linked tables.

If you wanted to know how to list the fields and their properties as well,
see:
http://allenbrowne.com/func-06.html

If you want to document them, there is a built-in documenter under:
Tools | Analyze
or a better one at:
http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html