Please help me how to write a Query to change the primary
key constraint from 1 attribute to another attribute in a
table

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


Please Help Members By Posting Answers For Below Questions

How to Truncate Table in Oracle

909


What is the minimum client footprint required to connect c# to an oracle database?

802


What is varray?

820


What are the different oracle database objects?

840


How to use windows user to connect to the server?

766


How to list all user accounts in oracle?

828


How remove data files before opening a database?

786


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1793


Explain the use of indexes option in exp command.

805


What are the differences between blob and clob in oracle?

823


What do you understand by a database object? Can you list a few of them?

816


How to write a left outer join with the where clause in oracle?

862


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2077


What is a trigger and what are its types?

833


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2023