1 ALTER TABLE table-name 2+ 2.0 ADD 2.0.1! COLUMN 2.0.1.1 column-definition 2.0 ALTER 2.0.1! COLUMN 2.0.2 column-alteration 2.0 DROP 2.0.1! COLUMN 2.0.1.1 column-name 2.0.1.2! CASCADE 2.0.1.2? 2.0.1.2 RESTRICT 2.0 ADD 2.0.1 unique-constraint 2.0.1 referential-constraint 2.0.1 check-constraint 2.0 DROP 2.0.1 PRIMARY KEY 2.0.1.0 UNIQUE 2.0.1.0 FOREIGN KEY 2.0.1.0 CHECK 2.0.1.0 CONSTRAINT 2.0.1.1 constraint-name 2.0.1.2! CASCADE 2.0.1.2? 2.0.1.2 RESTRICT 2.0 ADD partitioning-clause 2.0 DROP PARTITIONING 2.0 ADD PARTITION 2.0.1? partition-name 2.0.1.1 boundary-spec 2.0.1 integer 2.0.1.1 HASH PARTITIONS 2.0.1.1 HASH PARTITION 2.0 ALTER PARTITION partition-name boundary-spec 2.0 DROP PARTITION partition-name 2.0.1 DELETE ROWS 2.0.1 PRESERVE ROWS 2.0 ADD 2.0.1! MATERIALIZED 2.0.1.1 QUERY 2.0.1.2 materialized-query-definition 2.0 ALTER 2.0.1! MATERIALIZED 2.0.2 QUERY materialized-query-table-alteration 2.0 DROP 2.0.1! MATERIALIZED 2.0.2 QUERY 2.0ACTIVATE NOT LOGGED INITIALLY 2.0.1?WITH EMPTY TABLE 2.0.0NOT VOLATILE 2.0.0VOLATILE 2.0.1!CARDINALITY
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.