ALTER TRIGGER

ALTER TRIGGER

Syntax

alter_trigger ::=

Prerequisites

Only the SYS user, the owner of the schema containing the trigger, and users having the ALTER ANY TRIGGER system privilege can execute the ALTER TRIGGER statement.

Description

This statement is used to enable, disable, or compile a specified database trigger.

user_name

This is used to specify the name of the owner of the trigger to be altered. If it is omitted, Altibase will assume that the trigger to be altered belongs to the schema of the user connected via the current session.

trigger_name

This is used to specify the name of the trigger to alter.

ENABLE

This is used to enable the trigger.

DISABLE

This is used to disable the trigger.

COMPILE

This is used to explicitly compile the trigger, regardless of whether or not it is valid. Explicit recompiling helps reduce the load on the system incurred by automatically compiling invalid triggers when they need to fire.

Example

<Query> This is used to disable a trigger so that it does not fire automatically. More examples involving the del_trigger trigger can be found in the explanation of the CREATE TRIGGER statement.

iSQL> ALTER TRIGGER del_trigger DISABLE;
Alter success.