PRIMARY KEY | UNIQUE KEY |
NULL value is not allowed | NULL is allowed, subject to the condition that only a single NULL is allowed. Inserting more null throws “Cannot insert duplicate key” error. |
Table can have only one PRIMARY KEY constraint defined | Table can have multiple UNIQUE KEY constraints Defined |
By default, if a clustered index is not defined already on the table, defining a PRIMARY KEY constraint results in a clustered index with same name as PRIMARY KEY | By default non-clustered index is create when a UNIQUE KEY constraint is added. |
Purpose is to provide a unique identity to each row | Purpose is to avoid duplication |
Tuesday, June 28, 2011
Difference between PRIMARY KEY and UNIQUE KEY
Subscribe to:
Post Comments (Atom)
Vercel Mongo Integration
Click continue Press “I Acknowledge” Multiselect vercel projects Click “ “Connect and ...
-
http://www.sommarskog.se/share_data.html How to Share Data Between Stored Procedures An SQL text by Erland Sommarskog, SQL Server MVP. M...
-
Most of the google tutorials on keras do not show how to display a confusion matrix for the solution. A confusion matrix can throw a clear l...
-
This error means you have created the DbContext but not configured/added it to the project using either DI in startup.cs or by using DbCon...
No comments:
Post a Comment