Edit a user-defined function to change the parameters, permissions, or other properties.
PrerequisitesÂ
Before you can edit a user-defined function, be sure the data server that contains the user-defined function 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
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
you want to edit, and select
Edit.
-
Edit the user-defined function
properties.
Editor
Tab |
Description |
General |
- Change the Name.
- Enter a description in the
Comment field.
- Specify Parameters and their corresponding datatypes, input or output status, and defaults. To delete a parameter, highlight
it and click
Delete. To delete all parameters, click
Delete All. Use
Up and
Down to change the order
of parameters listed.
- Select a Return type.
- Select On Exception Resume to use Transact-SQL error handling in the event of an exception or error.
- Select Deterministic if the user-defined function does not need to be reevaluated every time it is used in a query.
|
Source |
Manually edit the SQL code in the Source page. To display line numbers for the SQL code, right-click in the left margin, and choose Show Line Numbers.
|
Permissions |
Set permissions for the user-defined function. You can
specify
Granted With Grant Option or Inherited permissions for the listed roles. |
DDL |
View the DDL for the user-defined function (read-only). |
-
Select
from the main WorkSpace menu.