By default, primary key creates clustered index on the column and then enforces the uniqueness of the column whereas the unique key, by default creates a non-clustered index.
- By default, creates Clustered index
- Doesn’t allow null
- Table can have only one Primary Key ( Can include multiple columns together )
- By default, creates non clustered index
- Accepts null value
- Table can have many unique keys
Enter your email address to subscribe to this blog and receive notifications of new posts by email.