Rename View

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