15.00 - Altering All Triggers on a Table - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

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.