Does any one know how to do a script (or has one) that will loop through every field of a given table and retrieve its field name, type and size?
by size, i mean:
- if type text, size = 15
- if type = number, size = long
- if type = yes/no, size = true/false
Ideally, i'd store this info in a 4-field table (table, name, type, size), and use in a report to print and document.,
Any help will be appreciated