SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-49
ALTER VIEW Statement
ALTER VIEW Statement
This section describes the ALTER VIEW statement and examples illustrating the
statement.
Considerations for ALTER VIEW
Example of ALTER VIEW
The ALTER VIEW statement alters a view by performing the following actions:
•
Renaming an object within a schema
•
Modifying a view by changing one or more view file attributes
•
Enabling or disabling Similarity Checks. This is supported from SQL/MX Release
3.2
name
specifies the name of the view to alter.
RENAME TO new-view-name
changes the logical name of the view.
new-view-name
specifies the new ANSI name of the view. The new ANSI name of the view
cannot be qualified; the renamed view remains in the current catalog and
schema.
ALTER VIEW name alter-action
alter-action is: {rename-action | similarity-check-action}
rename-action is:
RENAME TO new-view-name
similarity-check-action is:
[{ENABLE | DISABLE} SIMILARITY CHECK]
Note.
•
Renaming a view changes the text of referencing views, RI constraints, and triggers to
refer to the new name.
•
RENAME TO changes the redefinition timestamp of the affected view. However, the tables
referenced by the view are not affected
.