ON COMMIT DELETE/PRESERVE ROWS | CREATE TABLE | Teradata Vantage - 17.10 - ON COMMIT DELETE/PRESERVE ROWS - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

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

The following table explains how session mode affects the timing of the ON COMMIT action.

In this session mode … The ON COMMIT action is applied at this time …
ANSI when the application issues a COMMIT statement.
  • The end of each request (implicit transaction).
  • When the ET statement is processed (explicit transactions).

If you are using nested BT statements, then ON COMMIT is applied when the ET for the outermost BT is processed.