ALTER PROCEDURE syntax

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 datatype [, var datatype …])]
[RETURNS (var datatype [, var datatype …])]
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 statementon page 1-5).