Changing the primary key on existing DB2 Table

Changing the primary key on existing DB2 Table How to change the primary key on an existing DB2 Table? If you want to change the primary key of a table that already exists then you can use the following ALTER query

ALTER TABLE Table_Name DROP PRIMARY KEY;

ALTER TABLE Table_Name ADD PRIMARY KEY (Column_One, Column_Two);

Where Table_Name is the name of the DB2 table for which you wish to  change the primary key and Column_One and Column_two are the column  names which will be used as Primary Key. ; ; ; ;