DROP PRIMARY KEY Clause

Description

You can delete a primary key constraint defined for a table by using the DROP PRIMARY KEY clause. You do have to specify the name of the primary key constraint because only one primary key can be defined by table.  

Syntax

ALTER [ TABLE | CLASS ] table_name DROP PRIMARY KEY

Example

ALTER TABLE a_tbl DROP PRIMARY KEY;