Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Using Procedures, Triggers, and Batches » Introduction to procedures

Creating procedures Next Page

Altering procedures

You can modify an existing procedure using either Sybase Central or Interactive SQL. You must have DBA authority or be the owner of the procedure.

In Sybase Central, you cannot rename an existing procedure directly. Instead, you must create a new procedure with the new name, copy the previous code to it, and then delete the old procedure.

In Interactive SQL, you can execute an ALTER PROCEDURE statement to modify an existing procedure. You must include the entire new procedure in this statement (in the same syntax as in the CREATE PROCEDURE statement that created the procedure).

For more information on altering database object properties, see Setting properties for database objects.

For more information on granting or revoking permissions for procedures, see Granting permissions on procedures and Revoking user permissions.

To alter the code of a procedure (Sybase Central)
  1. Open the Procedures & Functions folder.

  2. Select the desired procedure. You can then do one of the following:

  3. For more information, see ALTER PROCEDURE statement, CREATE PROCEDURE statement, and Creating procedures.