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 to create a new table by selecting rows from another table?

856

Can we protect our pl/sql source code?

817

Can we connect to ORACLE db using Windows Authentication?

962

what is the difference between data migration and production migration.

2083

What do database buffers contain?

786

How to run the anonymous block again?

855

How to define a data field as not null?

881

Can we store pictures in the database and if so, how it can be done?

818

How to pass parameters to procedures in oracle?

833

Is there a function to split a string in plsql?

808

1) Does oracle have any table which contain all the exceptions and it's code internally?

1528

What is translate in oracle?

862

Can sub procedure/function be called recursively?

775

What are the major difference between truncate and delete?

765

what is Single Byte Overhead...?

2315