NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-45
ALTER VIEW Statement
•
The following statement reuses a partition named $DISK5.SALES.ORDERS, in
which the new primary first key is 5000 after the partition is reused:
ALTER TABLE $DISK1.SALES.ORDERS REUSE PARTITION
$DISK5.SALES.ORDERS FIRST KEY “5000”
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 ServerWare 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 ServerWare 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. (See Security on page S-11
if you need more information.)
COLUMN col-name { HEADING string | NO HEADING }
specifies a default heading or no heading for the column col-name. (See
HEADING Clause on page H-1 for more information.)
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 } }