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.

See SQL Anywhere 11.0.1 > SQL Anywhere Server - SQL Usage > Stored Procedures and Triggers > Using procedures, triggers, and batches > Introduction to procedures > Altering procedures.

For information on altering database object properties, see Introduction to Sybase IQ > Managing Databases > Managing Procedures.

For information on granting or revoking permissions for procedures, see System Administration Guide: Volume 1 > Managing User IDs and Permissions > Managing Individual User IDs and Permissions > Granting Permissions on Procedures in Interactive SQL and System Administration Guide: Volume 1 > Managing User IDs and Permissions > Managing Individual User IDs and Permissions > Revoking User Permissions in Interactive SQL.

You can also modify procedures using the ALTER PROCEDURE statement.