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
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.
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.