Used Columns in Dictionaries - Teradata Vantage

Teradata® Open Table Format for Apache Iceberg and Delta Lake User Guide
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata Vantage
Release Number
20.00
Published
October 2025
ft:locale
en-US
ft:lastEdition
2026-06-17
dita:mapPath
qrj1749167830193.ditamap
dita:ditavalPath
lli1749584660955.ditaval
dita:id
bsr1702324250454

The following existing dictionary columns are now used to store and return the default table-level retentiondays values.

DBC.DBASE.ExtraField4

  • Returns the default table-level retentiondays defined for the database or user.
  • A NULL value indicates that no default table-level retentiondays is set for the database or user.
ExtraField4 INTEGER FORMAT '--,---,---,--9'

DBC.PROFILES.ExtraField5

  • Returns the default tablelevel retentiondays for all users or databases associated with the profile.
  • A NULL value indicates that the profile does not define a default tablelevel retentiondays.
ExtraField5 INTEGER