Renaming a Procedural Object

You can rename a procedural object.

  1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.
    Database Steps
    From an ASE connection profile
    1. Expand the Databases folder.
    2. Expand the tree for a database and then the tree for the appropriate schema owner.
    From a SQL Anywhere or Sybase IQ connection profile
    1. Expand the tree for a database.
    2. Expand the Schemas folder and then the tree for the appropriate schema owner.
  2. Locate the procedural object in the navigation tree.
    Procedural Object Description
    Stored procedures Expand the Stored Procedures folder.
    SQL Anywhere or Sybase IQ User-defined functions Expand the User Defined Functions folder.
    Triggers Expand the Tables folder, select the table in which the trigger resides, and then expand the Triggers folder.
    SQL Anywhere or Sybase IQ event handlers Expand the Events folder.
  3. Right-click the object and select Rename.
  4. Enter a new name in the Rename dialog and click OK.
    Note: Avoid using spaces in object names. Spaces may cause the renaming to fail.
  5. If there are unsaved changes, save them in the Saved Modified Resources dialog.
    1. (Optional) Select Always Save Modified Resources Automatically Prior to Renaming to avoid this step in the future.
    2. Click OK.
Next 

After renaming, find and update existing references to the renamed object.

Related concepts
Procedural Objects
Related tasks
Creating a Procedural object
Editing a Procedural Object
Using Visual SQL

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.