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 the Primary and Foreign key?

Answer Posted / dhirendra

Primary Key: This is a constraint which is always unique &
not null.

Foreign Key: This is a constraint which is just opposite to
Primary key. It can be not Null & can accept duplicate value
as well. Foreign key points to same table's primary key or
another table's primary key to make a relationship.

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cte sql?

1047


What is relationship? How many types of relationship are there?

1261


how to extract a unit value from a date and time? : Sql dba

1035


What is view? Can we update view

1519


What is the use of primary key?

1047


How do you take the union of two tables in sql?

1027


How to avoid using cursors?

1175


Why procedure is used in sql?

1083


What is pivot in sql?

970


Can function return multiple values in sql?

1098


Enlist the data types that can be used in pl/sql?

1106


What is offset in sql query?

1176


What is lookup table in sql?

1090


Explain the difference between drop and truncate commands in sql?

1108


What is sqlexception in java?

1034