15.10 - data type - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
Content Type
Programming Reference
Publication ID
English (United States)

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 Utilities, B035-1102. Explicit formatting applies to the parsing and to the retrieval of character strings.

For information on data types, see SQL Data Types and Literals, B035-1143.