what is the difference between primary key and foreign key?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vimal chauhan
Primary key does't allow null value
while foreign key allow null value
| Is This Answer Correct ? | 11 Yes | 1 No |
What is the difference between a default skin and a named skin?
what is strong name?
4 Answers Fidelity, Infosys, Microsoft, Shriram Value Services,
Explain the significance of routing? : asp.net mvc
What is the difference between Trace and Debug?
Give real time examples for polymorphism, encapsulation, inheritance..
Hi! Could any 1 please suggest me a free practice online exam for asp.net exams.. thanks
Out of ASP or ASP.NET which one is stateless?
What is OSI layer? Explain different layers.
What is cookieless session id explain in brief?
What is server components?
what is purpose of xml control in standard controls of asp.net
Can you explain what inheritance is and an example of when you might use it?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)