15.00 - Triggers, Partitioned Primary Indexes, and the ALTER TABLE Statement - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Triggers, Partitioned Primary Indexes, and the ALTER TABLE Statement

You must disable some triggers before you can perform an ALTER TABLE request that modifies or revalidates the primary index for a table.

 

IF you specify this clause in an ALTER TABLE request that modifies or revaluates the primary index …

THEN you must disable these triggers before you perform the request …

WITH DELETE

all DELETE triggers on table_name.

WITH INSERT

  • all DELETE triggers on table_name.
  • all INSERT triggers on save_table.
  • You can reenable the triggers after the ALTER TABLE request completes.