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 a primary key, and how is it different from a unique key?

Answer Posted / hr@tgksolutions.com

• Primary Key:
o Ensures each row in a table is unique.
o Cannot contain NULL values.
o A table can have only one primary key.
• Unique Key:
o Ensures all values in a column are unique.
o Can contain a single NULL value.
o A table can have multiple unique keys.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to create a new view in mysql? : Sql dba

892


What is consistency?

1060


What is a join?

1019


What is write ahead logging in sql server?

987


What are the uses of merge?

1118


How does postgresql compare to mysql?

986


Difference between truncate, delete and drop commands?

1022


Which command is used to delete a trigger?

1259


How many types of literals are available in pl sql?

1044


Can we commit inside a trigger?

942


How do you modify a table in sql?

1061


How many columns should be in an index?

901


How to sort the rows in sql.

1007


How can you create an empty table from an existing table?

1009


What are the two types of exceptions.

1105