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

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:

   • Edit the code directly on the SQL tab in the right pane.

   • Edit the code in a separate window by right-clicking the procedure and choosing Edit In New Window from the popup menu.

     Tip If you want to copy code between procedures, you can open a separate window for each procedure.

     For information about translating a procedure, see Using Sybase Central to translate stored procedures.

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