Delete Primary Key Constraint in DB2: Quick Guide
To remove a primary key constraint from a table, you can use the ALTER TABLE statement. The specific steps are as follows:
- To remove the primary key constraint, use the following syntax:
ALTER TABLE table_name DROP PRIMARY KEY;
- Replace table_name with the name of the table that contains a primary key constraint.
- By executing the above SQL statement, the primary key constraint will be successfully removed.
Please make sure that there are no foreign keys dependent on the primary key when deleting the primary key constraint. If there are foreign keys dependent on the primary key, you will need to delete the foreign key constraint first before removing the primary key constraint.
