Updated Online Help - Updated Online Help - 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 online help for the CREATE and MODIFY statements for DATABASE, USER, and PROFILE is updated to include the following syntax:

DEFAULT RETENTIONDAYS = { retention_days | NULL }

Where retention_days specifies the table-level retention period for an OFS or MOTF table. It is an unsigned integer between 1 and 90.

These updates are reflected in the following statements:

  • CREATE DATABASE
  • MODIFY DATABASE
  • CREATE USER
  • MODIFY USER
  • CREATE PROFILE
  • MODIFY PROFILE