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
What does asp stand for in asp.net?
Explain authorization levels in .net ?
Any disadvantages in Dataset and in reflection ?
What is client side state management?
How can I create master page in asp net?
how to include timer or counting time to display next page in asp.net
Can we have 2 web config files?
What is http response header?
Describe Segmentation With Paging?
What is cached data phone?
What are the advantages of the code-behind feature?
What is the server of asp.net?
How can you implement encapsulation in asp.net?
What is session mode in asp.net?
What happens if an ASP.NET server control with event-handling routines is missing from its definition?