16.20 - Example: Local Journaling - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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);