15.10 - WITH JOURNAL TABLE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

A definition for the permanent journal table for the data table being altered. 
The JOURNAL default for a base data table is determined either by the CREATE TABLE request that created the table or the default fallback specification for the database or user containing the table. You can override these defaults with an ALTER TABLE request.

table_name
The permanent journal table table_name need not reside in the same database or user as the data table.
 See SQL Fundamentals, B035-1141 for the rules for naming database objects.
database_name
The default database for the current session is assumed, unless you specify a database. 
The database must already exist and table_name must have been defined as its default permanent journal table.
user_name
The default database for the current user is assumed, unless you specify a user. 
The user must already exist and table_name must have been defined as its default permanent journal table.