Neoview SQL Reference Manual (R2.2)

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 196).
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 196).
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.
Example of ALTER VIEW
• This example adds a column:
ALTER VIEW persnl.project
RENAME TO persnl.project2
ALTER VIEW Statement 51