DEFAULT JOURNAL TABLE - 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 redefinition for the current journal table.

Specifying this option does not change the status of existing data tables in the modified database.

journal_table_name
Name of the default journal table. The journal_table_name parameter is required if this clause is specified without the DROP keyword.
database_name
If a database name is not specified, then the database being modified is assumed.
If the database being modified does not have a journal table, the system creates journal_table_name by default.
If a different database is specified, then it must already exist and journal_able_name must have been defined as its default journal table.
DROP DEFAULT JOURNAL TABLE
The DROP keyword removes the default status of the journal table currently defined as the default for the database being modified. If the journal table resides in the database being modified, DROP also deletes the table from the system.
An error message is returned if the DROP request would delete a journal table that is being used by active data tables.