You can use the routine editor to edit the source code and properties
of a routine, such as a stored procedure or user-defined function.
If you make source code changes using the Routine editor, you
must save the routine and then deploy it again to the database server to apply
the changes to the server version of the routine.
Restriction: In
the Database Explorer, you can view routine properties but you cannot change
them.
To edit the properties or source code of a routine:
- Switch to the Data perspective.
- In the Data Project Explorer, double-click a routine. The
editor displays the source code of the routine on the Source tab.
- Edit the source code as required. Content assistance
is available in the routine editor for table and column names. To use content
assistance, type a schema or table name followed by a period (.) character
to see a list of available tables or columns in the connection that you are
working with.
- Optional: Click one of the tabs at the bottom of the
editor to display the properties of the routine. If a property
is available to edit, it is displayed in a field with a white background.
If it is not available to edit, it is displayed in a field with a gray background.
The only user-defined function (UDF) property that you can edit is the comment.
- Make the desired changes, and click File > Save.
The properties or source code of the routine are changed.