Alter Table Column To Primary Key Or Identity (Oracle)

January 11, 2019January 11, 2019 marifnst Oracle Leave a comment

ALTER TABLE YOUR_TABLE_NAME ADD CONSTRAINT PK_CONSTRAINT_NAME PRIMARY KEY (YOUR_COLUMN_NAME);

ALTER TABLE YOUR_TABLE_NAME ADD ( YOUR_COLUMN_NAME INT GENERATED AS IDENTITY );

CMIIW