ALTER TRIGGER Syntax Elements

ALTER TRIGGER Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

Language

English (United States)

Last Update

2024-04-03

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

database_name: Name of the database containing the trigger definition if not the default database for the trigger_name or table_name.
user_name: Name of the user containing the trigger definition if not the default database for the trigger_name or table_name.
trigger_name: The name of the trigger to be altered.  If you specify trigger_name you can alter only one trigger at a time.
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: Disables the named trigger or all triggers on the named table.
Disabled triggers exist, but cannot run unless re-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 make sure of the correct execution precedence.
table_name: The name of the table on which triggers are to be enabled or disabled.