Datatype short forms in Teradata

When we help table in Teradata, datatype is represented in short forms. below is list of datatype and it respective short forms.

• 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

• HM = INTERVAL HOUR TO MINUTE

• HR = INTERVAL HOUR

• HS = INTERVAL HOUR TO SECOND

• I1 = BYTEINT

• I2 = SMALLINT

• I8 = BIGINT

• I = INTEGER

• MI = INTERVAL MINUTE

• MO = INTERVAL MONTH

• MS = INTERVAL

• MINUTE TO SECOND

• PD = PERIOD(DATE)

• PM = PERIOD

(TIMESTAMP(n) WITH TIME

ZONE)

• PS = PERIOD

(TIMESTAMP(n))

• PT = PERIOD(TIME(n))

• PZ = PERIOD(TIME(n) WITH

TIME ZONE)

• SC = INTERVAL SECOND

• SZ = TIMESTAMP WITH

TIME ZONE

• TS = TIMESTAMP

• TZ = TIME WITH TIME

ZONE

• YM = INTERVAL YEAR TO

MONTH

• YR = INTERVAL YEAR

• UT = UDT Type