Neoview SQL Reference Manual (R2.3)

ALTER VIEW Statement
• “Syntax Description of ALTER VIEW”
• “Example of ALTER VIEW”
The ALTER VIEW statement adds a column to a Neoview SQL table. See “Database Object
Names” (page 206).
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 206).
RENAME 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 operation occurs.
Authorization and Availability Requirements
To create a view, you must be the must be the view owner, the schema owner, services ID, or be
granted the ALTER or ALTER_TABLE privilege.
Example of ALTER VIEW
• This example adds a column:
ALTER VIEW persnl.project
RENAME TO persnl.project2
ALTER VIEW Statement 51