Existing name for the view.
- Optional name of the containing database or user for the view to be renamed if other than the current database or user.
- You cannot use this statement to change the database or user qualifier for the view.
The following request renames the staff_info view as staff_information.
RENAME VIEW staff_info TO staff_information;