Oracle Primary Key: Setup Guide

1 year ago
Liam
1 minute

One way to set a primary key for a table in an Oracle database is by using the ALTER TABLE statement to add a primary key constraint. Here is an example:

ALTER TABLE table_name
ADD CONSTRAINT pk_table_name PRIMARY KEY (column_name);

In the example above, table_name is the name of the table to which the primary key constraint is being added, and column_name is the name of the column to be used as the primary key. Oracle also allows you to specify the primary key constraint directly when creating the table, as shown below:

CREATE TABLE table_name (
   column1 datatype PRIMARY KEY,
   column2 datatype,
   ...
);

This way, the primary key constraint will be set when creating the table.

bannerAds