<< DROP PROCEDURE | FB 2.5 Language Reference | SEQUENCE or GENERATOR >>
<< DROP PROCEDURE | FB 2.1 Language Reference | SEQUENCE or GENERATOR >>
<< RECREATE EXCEPTION | FB 2.0 Language Reference | RECREATE TABLE >>

RECREATE PROCEDURE

Available in: DSQL

Added in: 1.0

Description

Creates or recreates a stored procedure. If a procedure with the same name already exists, RECREATE PROCEDURE will try to drop it and create a new procedure. RECREATE PROCEDURE will fail if the existing SP is in use.

Syntax

Exactly the same as CREATE PROCEDURE.

Restriction on recreating 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:
Stored Procedure
DROP PROCEDURE
CREATE PROCEDURE
ALTER PROCEDURE

back to top of page
<< DROP PROCEDURE | FB 2.5 Language Reference | SEQUENCE or GENERATOR >>
<< DROP PROCEDURE | FB 2.1 Language Reference | SEQUENCE or GENERATOR >>
<< RECREATE EXCEPTION | FB 2.0 Language Reference | RECREATE TABLE >>