Share via


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 Visual Studio Settings.

To rename a view

  1. Create a new view and give it the name you want.

  2. Open the old view in the Query and View Designer.

  3. Copy all of the text in the SQL pane.

  4. Return to the new view and paste the text.

See Also

Other Resources

Working with Views