SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-42
Considerations for ALTER VIEW
The ALTER VIEW statement renames an object within the schema.
name
specifies the name of the view to alter.
RENAME TO new-view-object-name
changes the logical name of the view.
new-view-object-name
specifies the new ANSI name of the view. The new ANSI name of the view
cannot be qualified. However, the renamed view will remain in the current
catalog and schema.
Considerations for ALTER VIEW
Authorization and Availability Requirements
To alter a view, you must own its schema or be the super ID or object owner.
Renaming a View
You can use the rename option to change the name of a view. The following are the
prerequisites for renaming a view:
•
The view and its file label must be available.
•
The new ANSI name must not already exist within the schema.
Effects on TMF
Rename
For information on effects of rename option on TMF, see Effects on TMF
on page 2-33.
ALTER VIEW name alter-action
alter-action is:
RENAME TO new-view-object-name
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
.