System-Derived and System-Generated Column Data Types - Teradata VantageCloud Lake

Lake - Database Reference
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

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