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	Expand the Databases folder. Expand the tree for a database and then the tree for the appropriate schema owner.
   From a SQL Anywhere or Sybase IQ connection profile	Expand the tree for a database. Expand the Schemas folder and then the tree for the appropriate schema owner.

2. Find an existing procedural object.

   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 events	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: Do not use spaces in object names. Spaces could cause the renaming to fail.
5. (Optional) 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.

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

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com