Archives of the TeradataForum

Message Posted: Thu, 03 Aug 2006 @ 13:58:28 GMT

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

If you are writing an app to do this (rather than SQL) you can use the ODBC function SQLColumns() to fetch this information.

If you want to use SQL then use:

     HELP COLUMN ..*

You will need to translate the values returned in the 'Type' column.

     CF - CHARACTER FIXED
     CV - CHARACTER VARYING
     I  - INTEGER
     etc.

The other columns will depend on the data type.

Use 'Max Length' for character columns.

Use 'Total Digits' and 'Fractional Digits' for Numerics.

Mike Dempsey
Teradata Client Tools

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