SQL statement for column information

[leegold2]

Is there an SQL statement that will give me column information? For a table I want to know the data type and of course colum/Attribute name for each column.

I know there are VB ways of doing it, but I'm looking for a purely SQL way.

Thanks

 

[dhookom]

There is no "purely SQL way" of querying column/field information from Access/JET tables.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[cmmrfrds]

It is not clear what you mean by pure SQL? If you want the data returned as a recordset then ADO has the OpenSchema Method. I suppose if you want to write a Select Statement that you could use the Hidden tables in Access, but this seems unnecessary for any requirement I can think of right off. Perhaps if you explain the requirements a good solution can be found.

 

[leegold2]

My requirements: I need SQL access to table with Python. I usually use ODBC. But I do not know if there's a way with ODBC to specifically find out if a table has BLOB and/or MEMO columns. ie what are the data types for each column in a table?

It sounds like ADO is the way. Thanks

 

[JerryKlmns]

leegold2

It 's either DAO.TableDef.Field(?).Type property or ADOX.Table.columns(?).Type Property or a recordset on the table to check the field's type property.

 

[cmmrfrds]

It sounds like you are using linked tables in Access. What is the database engine you are linked to? SQL Server? Oracle? These databases have data dictionaries that can return information on the tables. Do you want to see the native data type or the data type after it is mapped through ODBC in the linked table?