Journal Tables and the Default Map - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

If the CREATE DATABASE statement specifies a journal table and a default map, the journal table is created using this default map. The journal table map must be a contiguous map with the same AMPs as TD_GlobalMap.

If the CREATE DATABASE statement specifies a journal table without specifying a default map, the system determines the map for the journal table in the following order of precedence:
  • Default map, if defined, for the profile of the database creator. See the DEFAULT MAP option of CREATE PROFILE.
  • Default map, if defined, for the database creator. See the DEFAULT MAP option of CREATE USER.
  • System-default map.