python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
Difference between Primary key

SQL Server "Primary Key", "Unique Key" and "Foreign Key" [Database]

The PRIMARY KEY and UNIQUE KEY both are similar and it used to apply the uniqueness of the columns and  also used for uniquely identify each row in database tables.

The major difference between Primary key, Unique key and Foreign Key as given below.

            Primary Key

1.       A primary key cannot accept null values.           
2.       A primary key must be unique.
3.       By default,  primary key create only one clustered index in the database .
4.       Each table can have one and only one primary key.
5.       Each table can have one and only one clustered index.
6.       Primary key can be made foreign key into another table.
7.       PK support auto increments.

Unique Key

1.       A unique key can accept only single null value.
2.       A unique key does not have to be the primary key.
3.       By default, unique key create non-clustered index.
4.       Each table can have more than one unique key.
5.       Unique key cannot made foreign key into another table.
6.       UK not support auto increments.

Foreign Key

1.       The foreign key is a field in the table that is primary key in another table.
2.       The foreign key do not create clustered or non clustered index automatically. You can create manually only.
3.       The foreign key can accept multiple null values.
4.       You can have more than one foreign key in a database table.
5.       There are actual advantages to having a foreign key be supported with a clustered index, but you get only one per table.

For example, you can seen in below pic for understanding about the same.

Reference links,

I hope you are enjoying with this post! Please share with you friends. Thank you!!

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - and
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like Powered by Blogger.
ASK Questions