SALES: 1-800-867-1380

ALTER PROCEDURE (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

Modifies a previously created procedure.

ImportantImportant
This topic is not maintained. For the current version, see ALTER PROCEDURE.

Syntax Conventions (Azure SQL Database)


ALTER { PROC | PROCEDURE } [schema_name.] procedure_name 
    [ { @parameter [ type_schema_name. ] data_type } 
    [ VARYING ] [ =default ] [ [ OUT [ PUT ] 
    ] [ ,...n ] 
[ WITH <procedure_option> [ ,...n ] ]
AS 
     { <sql_statement> [ ...n ] }

<procedure_option> ::= 
    [ RECOMPILE ]
    [ EXECUTE_AS_Clause ]

<sql_statement> ::= 
{ [ BEGIN ] statements [ END ] }


This syntax diagram demonstrates the supported arguments and options in Microsoft Microsoft Azure SQL Database.

Microsoft Azure SQL Database does not support the following arguments and options with the ALTER PROCEDURE statement:

  • FOR REPLICATION

  • External methods

  • ENCRYPTION option

For more information about the arguments and the ALTER PROCEDURE statement, see ALTER PROCEDURE in SQL Server Books Online.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft