Columns and Data_Types

[DeltaCharlie]

I need a list of all the tables in the database with all their columns and the attributes for each column. Similar to Querying the Information_Schema in SQL.

 

[Allen Browne]

Tools | Analyze | Documenter.

If you wish to do it in code, you could loop through the TableDefs, and list
the Fields or each and their Properties. Example:
http://allenbrowne.com/func-06.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I need a list of all the tables in the database with all their columns and

the attributes for each column. Similar to Querying the Information_Schema
in SQL.