You can rename a view using sp_rename:
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 under “Identifiers”.
You can change the name only of 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.
