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
Define static member?
What is query string?
What is the difference between session.abandon() vs clear()?
Name the namespace which is used by ado.net?
Which tool you have done?
1.how to encrpt query string in asp.net? 2.there are 10000 records then i wnat display 5000 records one gridview and 5000 records another grid view what is the process?
What is syntax code to send email from an asp.net application?
Explain culture and uiculture values.
What is mvc in asp.net interview question? : Asp.Net MVC
What are the new features implemented in ASP.NET?
What is http post action?
What are the new web part controls in asp.net 2.0 ?
Can the validation occurs in server-side or client-side? If the validation occurs why should we do?
Explain managed code an un-managed code.
What is difference between cookies and cache?