17.05 - WITH JOURNAL TABLE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

This clause is required if the CREATE TABLE statement specifies some level of journaling, but a default journal table was not defined for the database in which the new table is being created.

If you specify permanent journaling for this table, but do not specify a journal table with this clause, then you must define a default permanent journal table for the containing database.

If a default permanent journal table was defined for the database, then this clause can be used to override the default.

You cannot add or modify journal options for a NoPI table or for a column-partitioned table.

Journal options are not supported for tables with row sizes greater than 64KB.

table_name
The name of the permanent journal table to be used for the data table being created.
table_name can be contained within the same database as the table being created or in a different database.
database_name
If you specify a database name, then that name must exist and table_name must have been defined as its default permanent journal name.
If you do not specify a database name, then the default database for the current session is assumed and table_name must have been defined as the default permanent journal table.
user_name
If you specify a user name, then that name must exist and table_name must have been defined as its default permanent journal name.
If you do not specify a user name, then the default user for the current session is assumed and table_name must have been defined as the default permanent journal table.