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
Elaborate differentiation between ViewState and SessionState?
Can you use Web API with ASP.NET Web Form?
Disable browser cache for entire ASP.NET website?
Are cookies client side or server side?
What is asp.net mvc? : asp.net mvc
Is there any property names “isnavigating”?
Can we use a static function with a non-static variable?
what are the ihttphandler and ihttphandlerfactory interfaces ?
What do you mean by query string?
Can you explain composite pattern?
What are the various ways to send content from one page to another?
In which event of the page life cycle, is the viewstate available?
What is redirectpermanent in asp.net?
Which method do you use to enforce garbage collection in .net?
there is two functions function a and function b like fun a(){.... ..... } fun b() { } in function b i write the coding to add two numbers and i need to dispaly the sum result in function a with out using global variable. how we do?