Data Type Attributes - Advanced SQL Engine - Teradata Database

Database Introduction

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qia1556235689628.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1091
lifecycle
previous
Product Category
Teradata Vantageā„¢

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 Teradata Vantageā„¢ - Data Types and Literals, B035-1143.