16.20 - column_name - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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 Teradata Vantage™ 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 Teradata Vantage™ 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 Teradata Vantage™ - Database 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 Teradata Vantage™ Data Types and Literals, B035-1143.