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 a trigger oracle?

1082

How to pass parameters to procedures in oracle?

1037

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1037

How to turn on or off recycle bin for the instance?

1072

How to convert dates to characters in oracle?

1030

What is the difference between substr & instr functions?

1216

What is the oracle implicit cursor?

1052

What are temporal data types in oracle?

1115

What are the ansi data types supported in oracle?

942

How to use attributes of the implicit cursor in oracle?

999

Explain the importance of .pll extension in oracle?

997

What types of joins are used in writing subqueries?

976

What are the differences between date and timestamp in oracle?

1041

How to create a stored function in oracle?

1099

Point the difference between translate and replace?

1081