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

Teradata Database SQL Data Definition Language Detailed Topics

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

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.