15.00 - System-Derived and System-Generated Columns - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

System-Derived and System‑Generated Columns

About System‑Derived Columns

As the name implies, system-derived columns are columns whose values are not created by users, but instead are derived dynamically by the system. Some system‑derived columns contain values that Teradata Database creates and maintains for internal use, while others contain values that are critical for user applications.

The following system-derived column types are supported by Teradata Database:

  • ROWID columns (see “ROWID Columns” on page 800)
  • PARTITION and PARTITION#Ln columns (see “PARTITION Columns” on page 801)
  • ROWID, PARTITION, and PARTITION#Ln columns are always system‑defined and their values are always system‑generated.