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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Stored procedures, triggers, batches, and user-defined functions » Procedures

 

Altering a procedure (Sybase Central)

You can alter an existing procedure.

Prérequis

You must be the owner of the procedure or have one of the following privileges:

  • ALTER ANY PROCEDURE system privilege
  • ALTER ANY OBJECT system privilege

Contexte et remarques

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.

 Task
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, double-click Procedures & Functions.

  3. Select the procedure.

  4. Use one of the following methods to edit the procedure:

    • In the right pane, click the SQL tab.

    • Right-click the procedure and click Edit in New Window.

      Tip

      You can open a separate window for each procedure and copy code between procedures.

    • To add or edit a procedure comment, right-click the procedure and click Properties.

      If you use the Database Documentation Wizard to document your SQL Anywhere database, you have the option to include these comments in the output.

Résultat

The code of the procedure is altered.

 See also