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 |
Can more than one person use the same login?
is gateway for sms continue connected for sending sms.how?
Name the namespace which is used by ado.net?
Describe the difference between inline and code behind.
Types of caching. How to implement caching?
Difference between ASP & ASP.NET Session State
What is server infrastructure?
What is difference between Server.Transfer and Response.Redirect in ASP.NET?
0 Answers Sans Pareil IT Services,
What is wrong with a line like this? DateTime.Parse(myString)
How many types of Stored Procedures in SQL Server
Explain the server control events of asp.net ?
To load your generated dataset with data which method do you invoke?
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)