17.05 - FALLBACK PROTECTION - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

Whether to create and store a duplicate copy of each table created in the new database.

The FALLBACK keyword used alone implies PROTECTION.

Sets the default to not provide duplicate copy protection for data tables created in the database. This setting can be overridden for a particular data table when the table is created.
You cannot use the NO FALLBACK option and the NO FALLBACK default on platforms optimized for fallback.