SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-30
ALTER TABLE Statement
ALTER TABLE name
{ RENAME new-name }
{ }
{ {| security-spec |} }
{ {| attribute-spec |} }
{ }
{ SIMILARITY CHECK { ENABLE | DISABLE } }
{ }
{ ADD COLUMN col-name data-type [ DEFAULT def }
{ [ NOT NULL ] ] [ HEADING string | NO HEADING ] }
{ }
{ COLUMN col-name { HEADING string | NO HEADING } }
{ }
{ PARTITION ARRAY }
{ { STANDARD | EXTENDED | FORMAT2ENABLED } }
{ }
{ DROP PARTITION part-name }
{ }
{ {[FROM KEY val [UP TO LAST KEY]]} }
{ { TO dest-part [ move-spec ] } }
{ { [WITH SHARED ACCESS [wsa-spec]] } }
{ { } }
{ {TO dest-part [ move-spec ] } }
{ { WITH SHARED ACCESS [wsa-spec] } }
{ [PARTONLY] MOVE{ } }
{ {([FROM FIRST KEY] UP TO KEY val } }
{ { TO dest-part [move-spec] } }
{ { [WITH SHARED ACCESS [wsa-spec]]) } }
{ { } }
{ {([FROM FIRST KEY] UP TO KEY val } }
{ { TO dest-part [ move-spec ], } }
{ { FROM KEY val [UP TO LAST KEY] } }
{ { TO dest-part [ move-spec ]) } }
{ }
{ {| { ALLOCATE int | DEALLOCATE } |} }
{ [PARTONLY] {| MAXEXTENTS int |} }
{ {| RESETBROKEN |} }
{ {| RECOVER INCOMPLETE SQLDDL OPERATION |} }
{ }
{ ADD PARTITION }
{ new-part add-spec }
{ }
{ REUSE PARTITION reused-part reuse-spec }
security-spec is:
{| { CLEARONPURGE | NOCLEARONPURGE } |}
{| NOPURGEUNTIL date |}
{| OWNER group-num,user-num |}
{| SECURE "rwep" |}