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.
See ”Altering procedures”in SQL Anywhere Server - SQL Usage.
For information on altering database object properties, see Chapter 4, “Managing Databases.” in Introduction to Sybase IQ.
For information on granting or revoking permissions for procedures, see “Granting permissions on procedures” and “Revoking user permissions” in Chapter 8, “Managing User IDs and Permissions,”in the System Administration Guide: Volume 1.
See also ALTER PROCEDURE statement and CREATE PROCEDURE statement in Reference: Statements and Options.
