17.10 - BEFORE JOURNAL - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

The number of before change images to be maintained.

If the JOURNAL keyword is specified without NO or DUAL, then a single copy of the image is maintained unless FALLBACK is in effect or is also specified.

If journaling is requested for a table that uses fallback protection, DUAL images are maintained automatically.

Permanent journaling is not supported for NoPI tables, column-partitioned tables, global temporary tables, or volatile tables.

Dual images are maintained.
A journal image is not maintained.