table_preservation - Advanced SQL Engine - Teradata Database

Action to perform when a transaction completes.

ON COMMIT

Delete or preserve the contents of an instance of a global temporary or volatile table when a transaction completes.

This option is valid for global temporary and volatile tables only.

DELETE ROWS

Clears an instance of a global temporary or volatile table of all rows.

DELETE is the default.

PRESERVE ROWS

Retains the rows in the global temporary or volatile table after the transaction commits.