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

How to check database size in Oracle?

1114

Is oracle the best database?

912

What is meant by a deadlock situation?

1047

Can we convert a date to char in oracle and if so, what would be the syntax?

956

What's dateware house and what's clustor with practicle example

2124

Does facebook use oracle?

977

How to use "while" statements in oracle?

1228

Can we write insert statement in function in oracle?

1025

What is a subquery in oracle?

1040

How do you bind variables in oracle?

927

How to delete a column in an existing table in oracle?

1008

How to define an oracle cursor variable?

972

What is the scope of a local variable?

994

What do you understand by a database object?

986

what are steps for interface? where is exchange rate defined in which table?

2053