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
Why is global asax is used for?
What is round trip in asp.net?
What is application in asp net?
What is difference cookie and session?
What is server side routing?
What is the size of Get method and how much data it can store?
Explain how can we inherit a static member?
What is the difference between trace and debug in asp.net?
What is ipostback?
Explain the advantages of asp.net.
Where the cookie value is stored?
What are client activated objects and server activated objects?
What is connection pooling and how to enable and disable connection pooling?
How long do session variables last?
What is the difference between CC and BCC?