Rename View
Syntax
Sp_rename ‘present
name’, ‘new name’;
Example-
Present Name or old name of view is mac2 but now I want to provide newview name to view so I am executing
above given query.
Old Name (mac2)
Figure: Image before executing query
New Name (NewView)
Figure: Image after executing query
