Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

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

  • table_name: Specifies the name of a table that has a primary key constraint to be deleted.
Example

ALTER TABLE a_tbl DROP PRIMARY KEY;