You can rename a
procedural
object.
-
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.
|
- 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. |
-
Right-click the object and select
Rename.
-
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.
-
If there are unsaved changes, save them in the
Saved Modified Resources dialog.
-
(Optional) Select
Always Save Modified Resources Automatically Prior to
Renaming to avoid this step in the future.
-
Click
OK.
NextÂ
After renaming, find and update existing references to the renamed
object.
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.