How to get Field Name and Field Size for a Table 1

[LyndonOHRC]

I've already asked this question on the Microsoft: Access Queries and JET SQL Forum and no one had a practical solution.

I'm using the following code to get the list of table names from a database then printing the field names from columnlist. I would like to print field name and field size if there is any way to do it.

<cfquery name="GetTableNames" datasource="ORI">
 SELECT Name
 FROM MSysObjects
 WHERE Type=1 AND Flags=0
</cfquery>
<cfoutput query="GetTableNames">
 <cfquery name="GetFieldNames" datasource="ORI">
  Select *
  From #GetTableNames.Name#
 </cfquery>
 #GetTableNames.Name# (#NumberFormat(GetFieldNames.RecordCount)# Records)<br>
 <cfloop from="1" to="#ListLen(GetFieldNames.columnlist)#" index="i">
  #ListGetAt(GetFieldNames.columnlist,i)#,<br>
 </cfloop>
</cfoutput>

Thanks

Lyndon

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

 

[philhege]

ODBC: No. ADO/ADOX/OLEDB: Yes.

Database field descriptions are stored as properties in the TableDef collection, and as such are not exposed through the ODBC driver.

See

http://groups.google.com/group/micr...+tabledef+ODBC&rnum=18&hl=en#fa45c67f728ed5cc

For a further explanation.

 

[philhege]

Clarification: Tabledefs contains all of the table properties, including field data types. Descriptions are another property accessible through the collection.

 

[LyndonOHRC]

Thanks. I wondered why I couldn't find any code examples.

Lyndon

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