Alter Table Column To Primary Key Or Identity (Oracle)

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 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *

Afiseaza emoticoanele Locco.Ro