Although changing the name of the view using the sp_rename command is allowed, it is advised to first delete the current view before creating a new one with the new name.
Syntax:
sp_rename old_view_name, new_view_name
Get a list of every view dependency. It is necessary to change any items, scripts, or programs that use the view to reflect the new name. Verify that the view’s previous name is replaced with the new name in all objects, programs, and scripts that reference it.
It is because Code and programs that depend on a view may not work if you rename it. These include other views, searches, stored procedures, user-defined functions, and client applications.
Big Data and SQL 