15.10 - Example: Local Journaling - 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)
Last Update
2018-06-05

As an example, given the following CREATE TABLE requests:

     CREATE TABLE cyk.test_1, NO FALLBACK, AFTER JOURNAL (
       x INTEGER, 
       y INTEGER) 
     PRIMARY INDEX(x);
    
     CREATE TABLE cyk.test_2, NO FALLBACK, NOT LOCAL AFTER JOURNAL (
       x INTEGER, 
       y INTEGER) 
     PRIMARY INDEX(x);
    
     CREATE TABLE cyk.test_3, NO FALLBACK, LOCAL AFTER JOURNAL (
       x INTEGER, 
       y INTEGER) 
     PRIMARY INDEX(x);

SHOW TABLE produces the following output:

     CREATE TABLE cyk.test_1, NO FALLBACK, NO BEFORE JOURNAL,
       NOT LOCAL AFTER JOURNAL (
       x INTEGER, 
       y INTEGER) 
     PRIMARY INDEX(x);
    
     CREATE TABLE cyk.test_2, NO FALLBACK, NO BEFORE JOURNAL,
       NOT LOCAL AFTER JOURNAL (
       x INTEGER, 
       y INTEGER) 
     PRIMARY INDEX(x);
    
     CREATE TABLE cyk.test_3, NO FALLBACK, NO BEFORE JOURNAL,
       LOCAL AFTER JOURNAL (
       x INTEGER, 
       y INTEGER) 
     PRIMARY INDEX(x);