15.10 - column_name - 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)

Specifies the name of one or more non-QITS columns, in the order they are to be defined for the table.

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

You can define up to 2,048 columns, including the mandatory QITS column, for a queue table.

data type
You must specify a single data type for each column_name.
Queue tables cannot contain columns with BLOB, CLOB, JSON, XML, UDT, ARRAY, VARRAY, Period, or Geospatial data types.
For information on data types and data type attributes, see SQL Data Types and Literals, B035-1143.
For information about converting data between data types, see SQL Functions, Operators, Expressions, and Predicates, B035-1145.
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 to the parsing and retrieval of character strings.
column attributes
One or more data definition phrases that define data for the column.
You cannot specify a character server data set of KANJI1. Otherwise, Teradata Database returns an error to the requestor.
Column data attribute specifications are optional. If you specify attributes for a column, you should define its data type prior to defining the attributes.