Examples Using ALTER TRIGGER

Examples using ALTER TRIGGER

Deactivating the set_cust_no trigger (switching it to the inactive status).
```
ALTER TRIGGER set_cust_no INACTIVE;
```
Changing the firing order position of the set_cust_no trigger.
```
ALTER TRIGGER set_cust_no POSITION 14;
```
Switching the TR_CUST_LOG trigger to the inactive status and modifying the list of events.
```
ALTER TRIGGER TR_CUST_LOG
INACTIVE AFTER INSERT OR UPDATE;
```

Switching the tr_log_connect trigger to the active status, changing its position and body.

ALTER TRIGGER tr_log_connect
ACTIVE POSITION 1
AS
BEGIN
  INSERT INTO LOG_CONNECT (ID,
                           USERNAME,
                           ROLENAME,
                           ATIME)
  VALUES (NEXT VALUE FOR SEQ_LOG_CONNECT,
          CURRENT_USER,
          CURRENT_ROLE,
          CURRENT_TIMESTAMP);
END

`CREATE OR ALTER TRIGGER`

Creates a trigger if it doesn’t exist, or alters a trigger

Available in

DSQL

Syntax

CREATE OR ALTER TRIGGER trigname
  { <relation_trigger_legacy>
  | <relation_trigger_sql>
  | <database_trigger>
  | <ddl_trigger> }
  {<psql_trigger> | <external-module-body>}

!! See syntax of CREATE TRIGGER for further rules !!

The CREATE OR ALTER TRIGGER statement creates a new trigger if it does not exist;otherwise it alters and recompiles it with the privileges intact and dependencies unaffected.