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 is http post and http get?
Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?
What are the types of session in asp.net?
How do you create a master page?
How do we ensure view state has not tampered?
How does the iis work?
How use Xml data in ASP.net?
How can you access the properties and controls of master pages from content pages?
How do u declare static variable and how it is declared and what is its lifetime?
How do you deploy your asp.net application?
Describe session handling in a webfarm?
What is the difference between WindowsDefaultLocation and WindowsDefaultBounds?
What are the server control tags in asp.net.?
Why is xap important?
What are directives in asp.net?