Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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 / chandana

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

What is a proxy class?

1037

What are the limitations of check constraint?

1022

How to view existing locks on the database?

1047

What is a subquery?

1115

What are the advantages of oracle 12c?

1174

What is the fastest query method to fetch data from the table?

1354

What is the usage of control file in oracle?

1078

What is a cursor and what are the steps need to be taken?

1196

How to run queries on external tables?

1035

How to count duplicated values in a column in oracle?

1036

What is an oracle database table?

1004

How to create a stored function in oracle?

1099

Is there an oracle sql query that aggregates multiple rows into one row?

968

How to experiment a data lock in oracle?

1052

How to shutdown your 10g xe server from command line?

1080