Archives of the TeradataForum
Message Posted: Thu, 22 Mar 2007 @ 15:45:48 GMT
| Subj: | | Re: How to get column types in views |
| |
| From: | | Dempsey, Mike |
You say you are using ODBC so just use the ODBC API function provided.
SQLColumns() returns not only the column names but also the data types and 'Nullable' (etc.) attributes. This works for both tables and
views.
If you are not using the API directly, but ADO.Net (or something) I can not give you the actual details. If I understand it correctly however
the catalog data was made available in either .Net 1.1 or 2.0.
Mike Dempsey
Teradata Client Tools
| 
