Neoview SQL Reference Manual (R2.4 SP2)

ALTER VIEW Statement
• “Syntax Description of ALTER VIEW”
• “Considerations for ALTER VIEW”
• “Example of ALTER VIEW”
The ALTER VIEW statement renames an object within the same schema. See “Database Object
Names” (page 230).
ALTER VIEW name alter-action
alter-action is:
RENAME TO new name
Syntax Description of ALTER VIEW
name
specifies the current name of the object. See “Database Object Names” (page 230).
RENAME TO new-name
changes the logical name of the object within the same schema.
new-name
specifies the new name of the object after the RENAME TO operation occurs.
Considerations for ALTER VIEW
Authorization and Availability Requirements
To alter a view, you must be the view owner, the schema owner, or be granted the ALTER or
ALTER_VIEW privilege.
Example of ALTER VIEW
• This example adds a column:
ALTER VIEW persnl.project
RENAME TO persnl.project2
54 SQL Statements