15.00 - ON COMMIT DELETE/PRESERVE ROWS - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
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 …


when the application issues a COMMIT request.


  • 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.

    Related Topics

    For in-depth information about partitioned primary indexes, including usage suggestions, refer to the following Teradata Database Orange Book.

  • Jerry Klindt, Paul Sinclair, Steve Molini, Jeremy Davis, Rama Krishna Korlapati, Hong Gui, and Stephen Brobst, Partitioned Primary Index Usage (Single-Level and Multilevel Partitioning), Teradata Database Orange Book 541-0003869E02, 2008.
  • For information about the syntax used to create global temporary and volatile tables, see “CREATE TABLE” in SQL Data Definition Language Syntax and Examples.

    For information about modifying the definition of a global temporary or volatile table, see “ALTER TABLE (Basic Table Parameters)” on page 31 and “ALTER TABLE” in SQL Data Definition Language Syntax and Examples.