15.00 - 15.10 - Data Type Attributes - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

You can define the attributes of a data value.

Core data type attributes that Teradata Database supports include the following.

 

Data Type Attribute

Description

NOT NULL

Specifies that the fields of a column must contain a value; they cannot be null.

UPPERCASE

Specifies that character data for a column is stored as uppercase.

[NOT] CASESPECIFIC

Specifies case for character data comparisons and collations.

FORMAT

Controls the display of expressions, column data, and conversions between data types.

TITLE

Defines a heading for displayed or printed results that is different from the column name, which is used by default.

AS

Assigns a temporary name to an expression.

NAMED

Assigns a temporary name to an expression.

NAMED is a Teradata extension to the ANSI standard. For ANSI compliance, use AS instead of NAMED.

DEFAULT

Specifies that a user-defined default value is to be inserted in the field when a value is not specified for a column in an INSERT statement.

WITH DEFAULT

Specifies that a system-defined default value is to be inserted in the field when a value is not specified for a column in an INSERT statement.

WITH TIME ZONE

Used with the TIME or TIMESTAMP data type to specify a TIME or TIMESTAMP value with a displacement from UTC as defined for the system.

CHARACTER SET

Specifies the server character set for a character column.

For a complete list of supported data type attributes and detailed information about each attribute, see SQL Data Types and Literals.