Before you can rename a user-defined function, be sure the data server that contains the user-defined function is
running and that you have created and established a connection to the data
server.
In the Databases folder in Enterprise Explorer, under the database connection profile,
expand
the
tree for a database, expand the
Schemas folder and then the tree for the appropriate schema owner.
Expand the
User Defined Functions folder, right-click the
user-defined function, and select
Rename.
Enter a new name
for the user-defined function, and click
OK.
Note:
Do not use spaces in object names. Spaces could cause the renaming to fail.