15.10 - WITH JOURNAL TABLE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.