17.05 - JOURNAL - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

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

The type of permanent journal image to be maintained for the table. The default is set by the CREATE DATABASE, CREATE USER, or MODIFY USER statement for the database in which the table resides. When you specify the JOURNAL keyword without also specifying AFTER or BEFORE, Vantage maintains both types of images. This option can appear twice in the same request: once to specify a BEFORE or AFTER image and again to specify the alternate type. You cannot add or modify journal options for a nonpartitioned NoPI table or for a column-partitioned table.

If you specify only one type of journaling, Vantage overrides only the default for that type. For example, if you specify AFTER, then BEFORE image journaling remains at its default setting. If you specify BEFORE and AFTER journaling, the two specifications must not conflict with one another.