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 primary key and foreign key?

Answer Posted / gaytriom

A primary key is a column which uniquely identifies the
records in a table. In a broad sense, a primary key is the
mixture of a unique key and an index: A collumn with a primary
key is indexed to deliver a faster query, and doesn't allow
duplicate values to ensure specific data.

A foreign key is a column (the child collumn) in a table which
has a corresponding relationship and a dependency on another
collumn (the parent collumn) that is usually in a different
table. Parent collumns can have multiple child collumns, but a
child collumn can only have one parent collumn.

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does asp stand for in asp.net?

980


Explain authorization levels in .net ?

1047


Any disadvantages in Dataset and in reflection ?

3259


What is client side state management?

966


How can I create master page in asp net?

949


how to include timer or counting time to display next page in asp.net

2157


Can we have 2 web config files?

971


What is http response header?

1111


Describe Segmentation With Paging?

1071


What is cached data phone?

1043


What are the advantages of the code-behind feature?

986


What is the server of asp.net?

1076


How can you implement encapsulation in asp.net?

13059


What is session mode in asp.net?

1056


What happens if an ASP.NET server control with event-handling routines is missing from its definition?

1121