DROP TRIGGER

<< CREATE OR ALTER TRIGGER | FB 2.5 Language Reference | RECREATE TRIGGER >>
<< CREATE OR ALTER TRIGGER | FB 2.1 Language Reference | RECREATE TRIGGER >>
<< DROP SEQUENCE | FB 2.0 Language Reference | RECREATE EXCEPTION >>

DROP TRIGGER

Available in: DSQL, ESQL

Restriction on dropping 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.

DROP TRIGGER no longer increments table change count

Changed in: 1.0

Description

In contrast to InterBase, Firebird does not increment the metadata change counter of the associated table when CREATE, ALTER or DROP TRIGGER is used. For a full discussion, see ALTER TRIGGER no longer increments table change count.

See also:
Trigger
ALTER TRIGGER
CREATE TRIGGER
DDL - Data Definition Language

back to top of page
<< CREATE OR ALTER TRIGGER | FB 2.5 Language Reference | RECREATE TRIGGER >>
<< CREATE OR ALTER TRIGGER | FB 2.1 Language Reference | RECREATE TRIGGER >>
<< DROP SEQUENCE | FB 2.0 Language Reference | RECREATE EXCEPTION >>