Triggers, Partitioned Primary Indexes, and the ALTER TABLE Statement - Advanced SQL Engine

Triggers, Partitioned Primary Indexes, and the ALTER TABLE Statement - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product

Advanced SQL Engine

Teradata Database

Release Number

17.10

Published

July 2021

Language

English (United States)

Last Update

2021-07-27

dita:mapPath

imq1591724555718.ditamap

dita:ditavalPath

imq1591724555718.ditaval

dita:id

B035-1184

lifecycle

Product Category

Teradata Vantage™

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

ALTER TABLE Request Modifies or Revalidates the Primary Index with this Option	Disable these Triggers
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.