| Firebird Documentation Index → Firebird 2.0 Language Ref. Update → DDL statements → RECREATE PROCEDURE |
|
|
|
Table of Contents
Find a more recent version at Firebird 5.0 Language Reference: 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.
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.
|
| Firebird Documentation Index → Firebird 2.0 Language Ref. Update → DDL statements → RECREATE PROCEDURE |