Chapter 9 SQL Statements
389
ALTER PROCEDURE statement
Use this statement to replace a procedure with a modified version, you must
include the entire new procedure in the ALTER PROCEDURE statement.
Also, to enable and disable a procedure for replication with Sybase
Replication Server.
ALTER PROCEDURE [
owner
.]
procedure-name
procedure-definition
procedure-definition
:
CREATE PROCEDURE syntax following the name
ALTER PROCEDURE [
owner
.]
procedure-name
… REPLICATE { ON | OFF }
Must be the owner of the procedure or be DBA.
Automatic commit.
"CREATE PROCEDURE statement" on page 453
Syntax 1 The ALTER PROCEDURE statement is identical in syntax to
the CREATE PROCEDURE statement except for the first word. Either
version of the CREATE PROCEDURE statement can be altered.
Existing permissions on the procedure are maintained, and do not have to be
reassigned. If a DROP PROCEDURE and CREATE PROCEDURE were
carried out, execute permissions would have to be reassigned.
Syntax 2 If a procedure is to be replicated to other sites using Sybase
Replication Server, you must set REPLICATE ON for the procedure.
Syntax 2 of the ALTER PROCEDURE statement has the same effect as the
sp_setreplicate
or
sp_setrepproc ’table’
Adaptive Server Enterprise system
procedures.
You cannot combine Syntax 2 with Syntax 1.
♦
SQL/92 Vendor extension
♦
Sybase Not supported by Adaptive Server Enterprise.
Function
Syntax 1
Syntax 2
Permissions
Side effects
See also
Description
Standards and
compatibility
To Next Page
Loading...