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

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

Teradata Vantage™ - 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

jbg1472252759029

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.