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...

what is the difference between unique and primary key

Answer Posted / divyarao

primary key accepts only values which has no duplication ,and does not accept null values . for a a table there should be only one primary key constraint.
whereas in unique key ,it accepts null values .here also there should not be any duplication ,a table may have more than one unique key constarint

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a hierarchical database?

1009


How can I create database in excel?

926


Enlist various types of interactions created by dbms?

1008


What do you mean by checkpoints in dbms?

881


Explain the use of assign statement in progress database?

905


What is meant by system analysis?

1087


What is a foreign key constraint?

1018


What is the use of database management system?

988


Define a relation schema and a relation.

1078


How do you create a database?

917


What do you mean by deadlock dbms?

1105


How are exceptions handled in pl/sql? Give some of the internal exceptions name?

1018


What is progress actional?

996


What are new features postgre 9.1?

985


Why its better to use files than a DBMS when there are multiple users to access the data

1181