Use of Constraint Attributes and Column Information | CREATE TABLE | Vantage - Data Type, Column Storage, and Constraint Attributes - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

Column storage attributes are a Teradata extension to ANSI SQL. 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. For more information, see Teradata Vantage™ - Database Utilities, B035-1102. Explicit formatting applies to the parsing and to the retrieval of character strings.

If you change the tdlocaledef.txt file and issue a tpareset command, the new format string settings affect only those tables that are created after the reset. Existing table columns continue to use the existing format string in DBC.TVFields unless you submit an ALTER TABLE statement to change it. For more information, see ALTER TABLE (Basic Table Parameters).

Not all data type attributes are supported for UDT, ARRAY, VARRAY, Geospatial, and Period column declarations, and no column storage or column constraint attributes are supported for those types.

You can specify server character sets for character data by specifying CHARACTER SET server_character_set for character columns.

The database supports the following server character sets.
  • LATIN
  • UNICODE
  • KANJISJIS
  • GRAPHIC

You cannot specify the server character set KANJI1.

The database automatically converts any existing character columns with a server character set of Kanji1 to a server character set of Unicode.