ALTER TABLE TABLE_NAME MODIFY COLUMN (COLUMN2 PRIMARY KEY);

Please help me how to write a Query to change the primary
key constraint from 1 attribute to another attribute in a
table

Question Posted / manvendra

Answer Posted / manvendra

ALTER TABLE TABLE_NAME
MODIFY COLUMN (COLUMN2 PRIMARY KEY);

Is This Answer Correct ?

1 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is oracle in java?

969

Is primary key indexed by default in oracle?

987

What is a trigger oracle?

1085

What are a cluster and non-cluster index?

1018

What is hash cluster in oracle?

1174

How to Truncate Table in Oracle

1154

Explain an index?

1134

Explain the use of compress option in exp command.

1021

What are the differences between blob and clob in oracle?

1089

State some uses of redo log files?

1007

How to create a new user account in oracle?

1020

What is a trigger and what are its types?

1227

Explain the characteristics of oracle dba?

1120

Why does oracle 9i treat an empty string as null?

1056

How do you find current date and time in oracle?

1047