Columns and Data_Types

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.

DeltaCharlie said:
I need a list of all the tables in the database with all their columns and
Click to expand...
the attributes for each column. Similar to Querying the Information_Schema
in SQL.
 
Back
Top