You can rename a procedural object in SQL Editor, whether or not it is currently open.
After renaming you must find and update existing references to the renamed object. For example, if a procedure named caller-proc references a procedure named proc1, and you rename proc1 to newproc1, you must edit the reference in caller-proc.
To rename a procedural object that is open in SQL Editor:
Highlight the object name and right-click.
Choose Rename object-type (Alt-Shift-R) from the context menu.
For example, to rename a stored procedure choose Rename Procedure.
Enter a new name in the Rename dialog and click OK.
The Warning dialog appears with the warning The reference will not be updated appears, unless you have disabled it.
(Optional) To avoid this warning in the future, click Do not remind me again and click OK.
If there are unsaved changes, complete the Saved Modified Resources dialog:
(Optional) Click Always save modified resources automatically prior to renaming to avoid this step in the future.
Click OK.
To rename a procedural object that is not currently open:
Right-click the object in its Database Explorer folder.
Choose Rename object-type (Alt-Shift-R) from the context menu.
For example, to rename a stored procedure choose Rename Procedure.
Enter a new name in the Rename dialog and click OK.
The Warning dialog appears with the warning The reference will not be updated, unless you have disabled it.
(Optional) To avoid this warning in the future, click Do not remind me again and click OK.
The procedural object is renamed, and the new name appears in Database Explorer.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com