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. ; ; ; ;