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

3 Answers
6392 Views
I also Faced
E-Mail Answers

Answer Posted / manvendra

ALTER TABLE TABLE_NAME
MODIFY COLUMN (COLUMN2 PRIMARY KEY);

Is This Answer Correct ?

1 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is merge in oracle?

1002

material view and view disadvantages?

1023

What are the limitations of check constraint?

974

What is the sid in oracle?

911

Describe varray?

1009

How to define an oracle sub procedure?

1069

What do you mean by merge in oracle?

945

What are the different oracle database objects?

1037

How to view all columns in an existing table?

880

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5443

How to loop through data rows in the implicit cursor?

1024

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1027

What suggestions do you have to reduce the network traffic?

909

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2215

How to put more than 1000 values into an oracle in clause?

980