AFTER JOURNAL - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-22
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantageā„¢

A change to the type of image to be maintained for the table. Any existing images are not affected until the table is updated.

NO
After-change images are not maintained for tables created by the specified user.
DUAL
Dual after-change images are maintained for tables created by the specified user.
LOCAL
Single after-image journal rows for non-fallback data tables created by the specified user are written on the same virtual AMP as the changed data rows.
NOT LOCAL
Single after-image journal rows for non-fallback data tables created by the specified user are written on another virtual AMP in the cluster.