Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → RECREATE TRIGGER
Firebird Home Firebird Home Prev: RECREATE TABLEFirebird Documentation IndexUp: DDL statementsNext: RECREATE VIEW

RECREATE TRIGGER

Table of Contents

Restriction on recreating used triggers

Tip

Find a more recent version at Firebird 5.0 Language Reference: TRIGGER

Available in: DSQL

Added in: 2.0

Description: Creates or recreates a trigger. If a trigger with the same name already exists, RECREATE TRIGGER will try to drop it and create a new trigger. RECREATE TRIGGER will fail if the existing trigger is in use.

Syntax: Exactly the same as CREATE TRIGGER.

Restriction on recreating used triggers

Changed in: 2.0, 2.0.1

Description: In Firebird 2.0 only, a restriction is in place which prevents anyone from dropping, altering or recreating a trigger or stored procedure if it has been used since the database was opened. This restriction has been removed again in version 2.0.1. Still, performing these operations on a live database is potentially risky and should only be done with the utmost care.

Prev: RECREATE TABLEFirebird Documentation IndexUp: DDL statementsNext: RECREATE VIEW
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → RECREATE TRIGGER