Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

DROP TRIGGER

Description

You can drop a trigger by using the DROP TRIGGER statement.

Syntax

DROP TRIGGER trigger_name [ ; ] 

  • trigger_name : Specifies the name of the trigger to be dropped.
Example

The following is an example of dropping the medal_trig trigger.

DROP TRIGGER medal_trig;

Caution
  • A user trigger (i.e. the trigger event is COMMIT or ROLLBACK) can be seen and dropped only by the owner.
  • Only one trigger can be dropped by a single DROP TRIGGER statement. A table trigger can be dropped by a user who has an ALTER authorization on the table.