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 | 

RENAME TRIGGER

Description

You can change a trigger name by using the TRIGGER reserved word in the RENAME statement.

Syntax

RENAME TRIGGER old_trigger_name AS new_trigger_name [ ; ]

  • old_trigger_name : Specifies the current name of the trigger.
  • new_trigger_name : Specifies the name of the trigger to be changed.
Example

RENAME TRIGGER medal_trigger AS medal_trig;

Caution
  • A trigger name must be unique among all trigger names. The name of a trigger can be the same as the table name in the database.
  • To rename a table trigger, you must be the trigger owner or granted the ALTER privilege on the table where the trigger belongs. A user trigger can only be renamed by its user.