LOGGING INCREMENTAL ARCHIVE ON FOR object_list Examples - 17.05 - Examples: Enable Incremental Restore - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

This example enables incremental restore on the database MyDB and sets the option to delete log rows.

LOGGING INCREMENTAL ARCHIVE ON FOR MyDB DELETE LOG ROWS;

This example enables incremental restore on the table tab1 in the current database and sets the option to delete log rows.

LOGGING INCREMENTAL ARCHIVE ON FOR tab1 DELETE LOG ROWS;