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 diffrence between debug class and trace class in asp.net ?
Advantage of Update Panel over Asp.net 2.0 + C#+ Microsoft Ajax 1.0
What is windows active directory authentication?
What is custom events?
How would you get ASP.NET running in Apache web servers - why would you even do this?
Which is the parent class of the ASP.NET server control?
0 Answers Sans Pareil IT Services,
How can we apply themes to an asp.net application?
What is the difference between session state and session variables ?
Difference between server.Execute and response.redirect ?
5 Answers Accenture, Keane India Ltd,
Difference between .NET and previous version?
Who creates jsessionid?
What is .net framework and what are the main components of 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)