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

How do you store pictures in a database?

949

How to write date and time literals in oracle?

945

When system tablespace is created?

967

What is a proxy object?

1008

Explain what are synonyms used for?

980

Difference between hot backup vs. Cold backup?

945

How to delete a user account in oracle?

912

Oracle

2319

How to write a query with a left outer join in oracle?

1002

How can I see all tables in oracle?

950

What to do if the binary spfile is wrong for the default instance?

998

How index is implemented in oracle database?

943

What is difference between truncate and delete?

973

How to pass parameters to procedures?

973

What is instant client oracle?

972