How to: Rename Views (Visual Database Tools)

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.

Caution noteCaution

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.

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.

Community Additions