Data Type Codes | HELP Statement | Teradata Vantage - Data Type Codes - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

The following table lists the data type codes reported by HELP statements and the data types they represent.

Data Type Code Data Type
++ TD_ANYTYPE
A1 ARRAY (one dimensional)
AN ARRAY (multidimensional)
I8 BIGINT
BO BINARY LARGE OBJECT
BF BYTE
BV BYTE VARYING
I1 BYTEINT
CF CHARACTER (fixed)
CV CHARACTER (varying)
CO CHARACTER LARGE OBJECT
D DECIMAL
DA DATE
F DOUBLE PRECISION

DOUBLE PRECISION, FLOAT, and REAL are different names for the same data type.

F FLOAT

FLOAT, DOUBLE PRECISION, and REAL are different names for the same data type.

I INTEGER
DY INTERVAL DAY
DH INTERVAL DAY TO HOUR
DM INTERVAL DAY TO MINUTE
DS INTERVAL DAY TO SECOND
HR INTERVAL HOUR
HM

INTERVAL HOUR TO MINUTE

HS INTERVAL HOUR TO SECOND
MI INTERVAL MINUTE
MS INTERVAL MINUTE TO SECOND
MO INTERVAL MONTH
SC INTERVAL SECOND
YR INTERVAL YEAR
YM INTERVAL YEAR TO MONTH
N NUMBER
D NUMERIC
PD PERIOD(DATE)
PT PERIOD(TIME(n))
PZ PERIOD(TIME(n) WITH TIME ZONE)
PS PERIOD(TIMESTAMP(n))
PM PERIOD(TIMESTAMP(n) WITH TIME ZONE)
F REAL

REAL, DOUBLE PRECISION, and FLOAT are different names for the same data type.

I2 SMALLINT
AT TIME
TS TIMESTAMP
TZ TIME WITH TIME ZONE
SZ TIMESTAMP WITH TIME ZONE
UT USER-DEFINED TYPE (all types)
XM XML