ALTER PROCEDURE syntax

From InterBase
Jump to: navigation, search

Go Up to Altering and Dropping Stored Procedures


The syntax for ALTER PROCEDURE is similar to CREATE PROCEDURE as shown in the following syntax:

ALTER PROCEDURE name
[(var data_type [, var data_type ])]
[RETURNS (var data_type [, var data_type ])]
AS
procedure_body;

The procedure <name> must be the name of an existing procedure. The arguments of the ALTER PROCEDURE statement are the same as those for CREATE PROCEDURE (see Arguments of the CREATE PROCEDURE statement on the page CREATE PROCEDURE syntax).

Advance To: