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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment