Type Classifier

Teradata Developer Guides

ft:locale
en-US
ft:lastEdition
2026-08-18
Field Type Description Default Value Required
Type Enumeration, one of:
BIT
TINYINT
SMALLINT
INTEGER
BIGINT
FLOAT
REAL
DOUBLE
NUMERIC
DECIMAL
CHAR
VARCHAR
LONGVARCHAR
DATE
TIME
TIMESTAMP
BINARY
VARBINARY
LONGVARBINARY
NULL
OTHER
JAVA_OBJECT
DISTINCT
STRUCT
ARRAY
BLOB
CLOB
REF
DATALINK
BOOLEAN
ROWID
* NCHAR
NVARCHAR
LONGNVARCHAR
NCLOB
SQLXML
UNKNOWN
Custom Type String