RENAME VIEW Command

Example   See Also

Renames a SQL view in the current database.

Syntax

RENAME VIEW ViewName1 TO ViewName2

Arguments

ViewName1

Specifies the name of the SQL view to be renamed.

ViewName2

Specifies the new name of the SQL view.

Remarks

The database containing the SQL view must be opened exclusively and must be current before the SQL view can be renamed. To open a database for exclusive use, include EXCLUSIVE in OPEN DATABASE.