DROP TRIGGER

DROP TRIGGER

Syntax

drop_trigger ::=

Prerequisites

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

Description

This statement is used to drop the specified trigger from the database.

user_name

This is used to specify the name of the owner of the trigger to be dropped. If omitted, Altibase will assume that the trigger 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 be dropped.

Example

<Query> Drop the trigger del_trigger from a table.

iSQL> DROP TRIGGER del_trigger;
Drop success.