RENAME VIEW

Description

You can change the view name by using the RENAME VIEW statement.

Syntax

RENAME [ TABLE |CLASS | VIEW | VCLASS ] old_view_name AS new_view_name [ ; ]

• old_view_name: Specifies the name of a view to be modified.
• new_view_name: Specifies the new name of a view.

Example

The following example shows how to rename a view name to game_2004.

RENAME VIEW game_2004 AS info_2004;