15.10 - trigger_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

The name of the trigger to be altered.
 If you specify trigger_name you can alter only one trigger at a time.

database_name
Name of the database containing the trigger definition if not the default database for the trigger_name.
user_name
Name of the user containing the trigger definition if not the default user for the trigger_name.
ENABLED
The named trigger or all triggers on the named table are to be enabled.
 Enabled triggers function as active database objects and follow normal trigger protocol.

DISABLED
The named trigger or all triggers on the named table are to be disabled. Disabled triggers continue to exist as database objects, but cannot execute. For a trigger to execute, it must first be enabled.
TIMESTAMP
The creation timestamp of the named trigger is to be replaced with the current timestamp. 
Altering the creation timestamp of a trigger changes its position in the default order of execution, when multiple triggers are defined on a table.
The TIMESTAMP option does not apply to a table.
You can use the TIMESTAMP option to change the order of execution of triggers, particularly triggers that were created without the ORDER clause. If you do not specify a TIMESTAMP, then the existing timestamp for the trigger is not changed.
ALTER TRIGGER uses the current time when adding a timestamp. To change the timings for multiple order-sensitive triggers defined on the same table, you must submit ALTER TRIGGER statements that change the timestamps in the required order to ensure the correct execution precedence.