15.00 - Altering All Triggers on a Table - 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)

Altering All Triggers on a Table

If you enter a table name instead of a trigger name, then ALTER TRIGGER enables or disables all the triggers defined on that table.

If some of the triggers on a table are in disabled state and some are enabled the effect of the ALTER TRIGGER command specified for a table name is as follows.

 

IF you specify this option …

THEN the effect is all the triggers defined on the named table that are in an …

ENABLED

disabled state are enabled.

The command has no effect on enabled triggers.

DISABLED

enabled state are disabled.

The command has no effect on disabled triggers.