17.05 - data type - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
January 2021
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

One or more phrases that define the data type for the column. For a list of data types you can specify, see Data Types Syntax.

You must specify a single data type for each column_name , except for those defined in a CREATE TABLE … AS request, where you cannot specify data types.

You must define the data type before you specify attributes. Column data attribute specifications are optional.

If you do not specify explicit formatting, a column assumes the default format for the data type. The default format can be specified by a custom data formatting specification (SDF) defined by the tdlocaledef utility. See Teradata Vantage™ - Database Utilities , B035-1102 . Explicit formatting applies to the parsing and to the retrieval of character strings.

For information on data types, see Teradata Vantage™ - Data Types and Literals, B035-1143.