Interested to Buy Any Domain ? << Click Here >> for more details...
Please help me how to write a Query to change the primary
key constraint from 1 attribute to another attribute in a
table
- 3 Answers
- 6695 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dinesh a.
You can assing only one primary key on a table , so you
can't modify directoly one column to another , you need to
drop first one then create on another attribute.
SQL>ct constraint_name,constraint_type from user_constraints
where table_name='EMP' and constraint_type='P';
CONSTRAINT_NAME C
------------------------------ -
SYS_C00125220 P
SQL> alter table emp drop constraint SYS_C00125220;
sql> alter table any_table add constraint my_cons_nm
primary key(column_of_tab)
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / chandana
YOU CANNOT CHANGE THE CONSTRAINTS DIRECTLY ON A COLUMN.
FIRST DROP THE CONSTARINT U HAVE CREATED AND THEN USE ALTER
COMMAND TO ADD CONSTARINT TO THE CORRECT COLUMN.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / manvendra
ALTER TABLE TABLE_NAME
MODIFY COLUMN (COLUMN2 PRIMARY KEY);
| Is This Answer Correct ? | 1 Yes | 5 No |
What is an Oracle Instance?
How to store pictures on to the database?
What is oracle database client?
how to select second mauximum value in a given table under salary column
How does oracle handle read consistency?
Explain the use of grant option in imp command.
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
what is the syntax of DROP command?
Does oracle charge for java?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
How to create an initialization parameter file?
What are the various oracle database objects?
Oracle General 
