ALTER PROCEDURE Statement

Replaces an existing procedure with a modified version. Include the entire modified procedure in the ALTER PROCEDURE statement, and reassign user permissions on the procedure.

Syntax

ALTER PROCEDURE [ owner.]procedure-name procedure-definition

Parameters

procedure-definition: – CREATE PROCEDURE syntax following the name

Usage

The ALTER PROCEDURE statement is identical in syntax to the CREATE PROCEDURE statement.

Existing permissions on the procedure are maintained and need not be reassigned. If a DROP procedure and CREATE PROCEDURE were carried out, execute permissions would have to be reassigned.

Side effects:

Automatic commit

Standards

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Not supported by Adaptive Server Enterprise.

Permissions

Must be the owner of the procedure or a DBA. Automatic commit.