15.10 - FALLBACK - 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 new default for duplicate copy protection of each data table subsequently created in the database. The current fallback setting for existing data tables remains unchanged.

PROTECTION
Optional keyword that you can specify with FALLBACK. The FALLBACK keyword used alone implies PROTECTION.
NO
Sets the default to not provide duplicate copy protection for data tables created in the database.

Example: Change fallback protection and space allocation options

Change fallback protection and space allocation options on the finance database as follows.

     MODIFY DATABASE finance AS 
     PERM = 75000000, 
     SPOOL = 150000000,
     NO FALLBACK,
     DROP DEFAULT JOURNAL TABLE = finance.journals;