Changing Stored Procedure and View Names
Provided by: FMS Development Team
There are times when you will need to change the name of a
view or stored procedure after the object has been created. In the
- Right-click on the object, to show the available sub-menu options.
- Select ‘Rename’.
- Change the name of the object.
A word of caution is needed when performing this action.
Renaming a stored procedure or a view does not change the name in the text
of the definition (i.e. “Create Procedure <name>”, “Create View <name>”). To
change the name of the text, you must modify the object directly.
If you do not make the proper modification, you will
encounter a problem when you script the object. When the object is scripted,
the name that appears in the text of the definition will become the name of
the object. In this case, the object name will be reverted back to the
Return to the tips page