System-Derived and System-Generated Column Data Types - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The following table lists the data types for system-derived and system-generated column data types:

Derived or Generated Column Data Type Default Title
OID VARBYTE None
ROWID
  • BYTE(10) for 2-byte partitioning
  • BYTE(16) for 8-byte partitioning
 None.

There is no default title for the ROWID keyword because you cannot specify ROWID in the select list of any DML request. You can only specify ROWID in a CREATE JOIN INDEX DDL request.
Identity column Any of the following.
  • BYTEINT
  • DECIMAL(n,0)

    The scale for a DECIMAL identity column must be 0.

  • INTEGER
  • NUMBER(n,0)

    Only a fixed NUMBER type is permitted for identity columns, and its scale must be 0.

  • NUMERIC(n,0)
  • SMALLINT
  • BIGINT

The upper limits for DECIMAL and NUMERIC types are the following.

  • DECIMAL(18,0)
  • NUMERIC(18,0)

You can define an identity column with more than 18 digits of precision, or even as a BIGINT or NUMBER(n,0) type, without the CREATE TABLE or ALTER TABLE request aborting, but the values generated by Vantage for the identity column remain limited to the DECIMAL(18,0) type and size.

 Default title for the column designated as an identity column.
PARTITION INTEGER PARTITION
PARTITION#L n
  • INTEGER for the 2-byte form of PPI.
  • BIGINT for the 8-byte form of PPI.
 PARTITION#L n