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
- 5870 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is oracle a programming language?
What is the difference between sharding and replication?
How to declare a local variable?
How do you tell what your machine name is and what is its IP address?
How to do clean up if create database failed?
How to use windows user to connect to the server?
What is different types of joins?
Explain cascading triggers.
Can we use bind variables in oracle stored procedure?
What is a Garbage Collection? and what is full recursive Garbage collection?
How do I spool to a csv formatted file using sqlplus?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is bulk copy or bcp in oracle?
Will you be able to store pictures in the database?explain.
What do you mean by merge in oracle and how can you merge two tables?
