16.20 - ON COMMIT DELETE/PRESERVE ROWS - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
Release Date
March 2019
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.