SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

A-29

Example—ALTER PROGRAM

This example statements give the program file ASERV to a new owner (12,201) and

set the PROGID file attribute. The first statement sets the owner ID, which

automatically turns off the PROGID attribute. The second statement turns on the

PROGID attribute.

ALTER PROGRAM ASERV OWNER 12,201;

ALTER PROGRAM ASERV PROGID;

ALTER TABLE Statement

ALTER TABLE is a DDL statement that:



Renames, changes security, changes file attributes, or enables or disables

similarity checks for a table



Adds a column to a table or changes the HEADING attribute for an existing column



Drops, moves, splits, reuses, or adds a table partition or changes file attributes of a

table partition

The ALTER TABLE statement supports several types of move and split operations,

including:



Moving an entire partition to another disk volume



Merging an entire partition into another existing partition



Splitting a partition and moving part into a newly created partition



Moving part of a partition into another existing partition.