Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → DROP PROCEDURE
Firebird Home Firebird Home Prev: DROP GENERATORFirebird Documentation IndexUp: DDL statementsNext: DROP SEQUENCE

DROP PROCEDURE

Restriction on dropping used procedures

Available in: DSQL, ESQL

Restriction on dropping used procedures

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: DROP GENERATORFirebird Documentation IndexUp: DDL statementsNext: DROP SEQUENCE
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → DROP PROCEDURE