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.05

17.00

Published

June 2020

Language

English (United States)

Last Update

2021-01-24

dita:mapPath

jpx1556733107962.ditamap

dita:ditavalPath

lze1555437562152.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.