How to: Rename Views
The name of a view cannot be changed but, rather, a new view must be created with the desired new name and the old view definition copied into the new view.
Warning
If you rename a view, code and applications that depend on the view may fail. These include queries, views, stored procedures, user-defined functions, and client applications. Note that these failures will cascade. Carefully consider any name change before making it.
Note
Renaming views is not fully available for connections to some database management systems.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.
To rename a view
Create a new view and give it the name you want.
Open the old view in the Query and View Designer.
Copy all of the text in the SQL pane.
Return to the new view and paste the text.