SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-50
ALTER VIEW Statement
ALTER VIEW Statement
ALTER VIEW is a DDL statement that changes the name, owner, or security attributes
of a view, changes the heading for a column of the view, or enables or disables
similarity checks for the view.
view-name
is the name of a view to alter (or an equivalent DEFINE).
RENAME new-name
changes the file and subvolume portions of the name of a view to those in the
Guardian name (or equivalent DEFINE) new-name, updating all catalog references
to reflect the change. If SMF is installed, new-name must be either a virtual or
direct name.
The fully expanded new-name must be unique among object names in the network
and new-name must have the same volume name as view-name. If the view is
managed by SMF, only the virtual name changes; the physical name on the
physical volume is preserved.
OWNER group-num,user-num
specifies the Guardian user ID for the new owner of the view.
SECURE "rwep"
specifies the new Guardian security string for the view. For more information, see
Security
on page S-11.
COLUMN col-name { HEADING string | NO HEADING }
specifies a default heading or no heading for the column col-name. For more
information, see HEADING Clause
on page H-1.
Changing a column heading in a view does not change the corresponding heading
in any view previously created on that view. A view inherits headings from
underlying tables and views when you create it, but the headings exist
independently.
ALTER VIEW view-name
{ RENAME new-name }
{ }
{ {| OWNER group-num,user-num |} }
{ {| SECURE "rwep" |} }
{ }
{ COLUMN col-name { HEADING string | NO HEADING } }
{ }
{ SIMILARITY CHECK { ENABLE | DISABLE } }