15.00 - Nontemporal Operations - Teradata Database

Teradata Database Temporal Table Support

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1182-015K

Nontemporal Operations

A nontemporal operation is an operation where the NONTEMPORAL prefix is used with an ALTER TABLE, CREATE TABLE AS (Copy Table Syntax), DELETE, INSERT, or UPDATE statement. Nontemporal operations allow modifications to be made to closed rows in transaction-time and bitemporal tables which are normally not allowed on tables with transaction time. These operations can circumvent the automatic history that is normally kept for these kinds of temporal tables. They can specify a transaction time when modifying and inserting rows, and can physically delete closed rows. These operations are normally not allowed on temporal tables that have transaction time. Use of the NONTEMPORAL keyword is discouraged in most situations, and requires the special NONTEMPORAL privilege. For more information see “NONTEMPORAL Privilege” on page 181.