Javatpoint Logo
Javatpoint Logo

Primary Key

In Oracle, Primary key is the column which has unique values, and it cannot be null. In a table, there can be only one primary key.

Primary Key - Using CREATE TABLE statement

Syntax:

Example

Primary Key in Oracle

Primary Key - Using ALTER TABLE statement

Syntax:

Example

Primary Key in Oracle Using Alter Table

Drop Primary Key

Syntax:

Example

Primary Key in Oracle Drop Primary Key

Disable Primary Key

Syntax:

Example

Primary Key in Oracle Disable Primary Key

Enable Primary Key

Syntax:

Example

Primary Key in Oracle Enable Primary Key
Next TopicTutorial




Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA