Menu ▼



Posted By :
avatarmrkraju
Total Views : 593

Difference between primary key and foreign key

Below are the differences between Primary Key and Foreign Key.

Primary Key Foreign Key
It will not allow NULL values. It will allow NULL values.
Primary Key can not contain duplicate values. Foreign Key allows duplicate values.
A table can have only one Primary Key. A table can have multiple Foreign Keys.
Clustered index will be created by defauult. Index will not be created automatically, need to be created manually.





comments powered by Disqus


Search dotnetlearners.com