Monday, December 23, 2013

How to add primary key constraint on oracle table

This is how you will add primary key constrain on exiting oracle table.

ALTER TABLE MY_TABLE_NAME ADD (CONSTRAINT PK_MY_TABLE_NAME PRIMARY KEY (COLUMN1, COLUMN2));

 Note: MY_TABLE_NAME is your some table name.  PK_MY_TABLE_NAME can you your pk_somename.

No comments:

Post a Comment