DROP PROCEDURE
<< CREATE OR ALTER PROCEDURE | FB 2.5 Language Reference | RECREATE PROCEDURE >>
<< CREATE OR ALTER PROCEDURE | FB 2.1 Language Reference | RECREATE PROCEDURE >>
<< DROP GENERATOR | FB 2.0 Language Reference | DROP SEQUENCE >>
DROP PROCEDURE
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.
See also:
ALTER PROCEDURE
CREATE PROCEDURE
EXECUTE PROCEDURE
Stored Procedure
DDL - Data Definition Language
back to top of page
<< CREATE OR ALTER PROCEDURE | FB 2.5 Language Reference | RECREATE PROCEDURE >>
<< CREATE OR ALTER PROCEDURE | FB 2.1 Language Reference | RECREATE PROCEDURE >>
<< DROP GENERATOR | FB 2.0 Language Reference | DROP SEQUENCE >>
