Drop Primary Key on DB2 Table How to drop an existing primary Key on a table? You will need to use the ALTER command to delete the primary key from the table. The following is an example of such query.
ALTER TABLE Table_Name DROP PRIMARY KEY;
Where Table_Name is the name of table on which you want to delete the primary key. ; ; ; ;