Rename a stored procedure from Enterprise Explorer to refer to the procedure by a new name.
PrerequisitesÂ
Before you can rename a stored procedure, be sure the data server that contains the stored procedure is
running, and you created and established a connection to the data
server.
-
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.
|
-
Expand the
Stored Procedures folder, right-click the
stored procedure you want to rename, and choose
Rename.
-
Enter a new name
for the stored procedure, and click
OK.
Note:
Do not use spaces in object names. Spaces could cause the renaming to fail.