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 / suresh kumar somayajula

Unique Key allows NULL value and a table can have more than
one UNIQUE KEY Constraint.

Primary Key is the combination of UNIQUE+NOT NULL,means it
won't allow NULL Values and a table can have only one
Primary Key.But a table can have Composite Primary Key.

Thank you,
Suresh

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is write ahead logging in DBMS?

1025


Explain Relational Algebra in RDBMS

1020


Which is best database?

862


What is the difference between a catalog and a database?

873


What are the two main functions of queries in databases?

1368


what is normalization? types of normalization? example of each form? how do u implement normalization in ur project?

1805


Explain armstrong rules? How they are complete and/or sound?

839


How to write udf s in delphi?

944


How do you backup a database?

929


What is atomicity in dbms?

883


Why are forms important in databases?

848


What are the different types of DBMS architecture?

1003


What is the first step in creating a database?

833


What is the sql 'in' clause?

896


When does checkpoint occur?

843