15.10 - column_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Specifies the name of one or more optional columns, in the order in which they and their attributes are to be defined for the table. Up to 2,048 columns can be defined for a table.

For information about naming database objects, see SQL Fundamentals, B035-1141.

data type
data type attributes
One or more data definition phrases that define data for the column.
You must specify a single data type for each column_name.
You cannot specify a BLOB, CLOB, UDT, or Period type for any column in a global temporary trace table. You can dump all the predefined attributes of a UDT into a trace table using FNC calls, however (see SQL External Routine Programming, B035-1147 for information about how to use FNC calls).
You cannot write Java strings into a global temporary trace table column defined with any of the following data types because the Java language does not support the types:
  • GRAPHIC
  • VARGRAPHIC
  • LONG GRAPHIC
Column data type attribute specifications are optional. If you specify attributes for a column, you should define its data type prior to defining the attributes.
The only valid constraints for global temporary trace table columns are NULL and NOT NULL.
If you specify NOT NULL, but the UDF does not return data, then that column is padded with appropriate values, depending on the data type.
You cannot specify DEFAULT or WITH DEFAULT column attributes for global temporary trace table columns.
If you do not specify explicit formatting, a column assumes the default format for the data type, which can be specified by a custom data formatting specification (SDF) defined by the tdlocaledef utility. See Utilities, B035-1102. Explicit formatting applies both to the parsing and to the retrieval of character strings.
You cannot define a temporal column for a global temporary trace table.
Data types and data type attributes are described in detail in SQL Data Types and Literals, B035-1143.