Archives of the TeradataForum

Message Posted: Fri, 19 Jan 2007 @ 07:46:46 GMT

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

Here are the descriptions from the Data Dictionary manual.

You can create a table in Teradata and store the columntype and the description for future reference.

     * AT = TIME
     * BF = BYTE
     * BO = BLOB
     * BV = VARBYTE
     * CF = CHAR
     * CO = CLOB
     * CV = VARCHAR
     * D = DECIMAL
     * DA = DATE
     * DH = INTERVAL DAY TO HOUR
     * DM = INTERVAL DAY TO MINUTE
     * DS = INTERVAL DAY TO SECOND
     * DY = INTERVAL DAY
     * F = FLOAT
     * GF = GRAPHIC
     * GV = VARGRAPHIC
     * HM = INTERVAL HOUR TO MINUTE
     * HR = INTERVAL HOUR
     * HS = INTERVAL HOUR TO SECOND
     * I1 = BYTEINT
     * I2 = SMALLINT
     * I = INTEGER
     * MI = INTERVAL MINUTE
     * MO = INTERVAL MONTH
     * MS = INTERVAL MINUTE TO SECOND
     * SC = INTERVAL SECOND
     * SZ = TIMESTAMP WITH TIME ZONE
     * TS = TIMESTAMP
     * TZ = TIME WITH TIME ZONE
     * YM = INTERVAL YEARTO MONTH
     * YR = INTERVAL YEAR
     * UT = UDT Type

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