You can rename a view using:
sp_rename objname , newname
For example, to rename titleview to bookview, enter:
sp_rename titleview, bookview
Follow these conventions when renaming views:
Make sure the new name follows the rules used for identifiers discussed in “Identifiers”.
You can change the name of only views that you own. The database owner can change the name of any user’s view.
Make sure the view is in the current database.
