Archives of the TeradataForum

Message Posted: Wed, 09 Nov 2005 @ 09:06:58 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

As you have noted, dbc.columns doesn't contain any datatype information. Neither does the help view command.

My guess is that SQL Assistant prepares a query (select *) against the selected view. A prepared query is like an executed query but it isn't actually executed. When the query is prepared, result set meta data becomes available. Part of the return information is a list of columns including their datatypes.

Using a prepared statement is the best way to get meta data about a table or view as it is not system dependent. That is, the same code would work against any DBMS that supported prepared statements (i.e. most if not all of them).

For what it is worth, I don't think any version of Teradata populated data type details in dbc.columns (at least for not as long as I can remember).

Regards

Glenn Mc

	<Prev	Next>		<<First	<Prev	Next>	Last>>