17.00 - DEFAULT JOURNAL TABLE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

Default table that is to receive the journal images of data tables created in the new database.

A database can contain only one default journal table. However, any table in a particular database can use a journal table in a different database.

You must define a table_name. The table is created in the new database, if you do not specify a database. Otherwise, the table is created in the database you specify.
For information about naming database objects, see Teradata Vantage™ - SQL Fundamentals, B035-1141.
If you specify another database, the database must exist and table_name must be defined as the default journal table.