CREATE OR ALTER PROCEDURE

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

CREATE OR ALTER PROCEDURE

Available in: DSQL

Added in: 1.5

Description

If the procedure does not yet exist, it is created just as if CREATE PROCEDURE were used. If it already exists, it is altered and recompiled. Existing permissions and dependencies are preserved.

Syntax

Exactly the same as for CREATE PROCEDURE.

See also:
Stored Procedure
DDL - Data Definition Language

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