Renaming a Stored Procedure

See Also

When you change the name of a stored procedure, that name is updated in your database and in the Stored Procedures folder of Data View as soon as you save the stored procedure.

To rename a stored procedure

  1. In Data View, expand the Stored Procedures folder.

  2. Right-click the name of the stored procedure that you want to rename.

  3. Choose Rename from the shortcut menu.

  4. Enter the new name for the stored procedure.

Stored procedures must have unique names. If you choose a name that is already assigned to another stored procedure in your project, an error message warns you that a stored procedure with that name already exists.

Note   If you change the name of a stored procedure in the editor, the save command will create a new version of the stored procedure with the new name. Any permissions associated with the original stored procedure are not carried forward.