Viewing and editing source code and properties for routines

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:

  1. Switch to the Data perspective.
  2. In the Data Project Explorer, double-click a routine. The editor displays the source code of the routine on the Source tab.
  3. 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.
  4. 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.
  5. Make the desired changes, and click File > Save.
The properties or source code of the routine are changed.

Feedback