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, PARTITION, and PARTITION#Ln columns are always system‑defined and their values are always system‑generated.