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)
How to check local and global angular versions
Use the command ng version (or ng v ) to find the version of Angular CLI in the current folder. Run it outside of the Angular project, to f...
-
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...
-
CONCLUSION : 1. Normally, use following two when you do not want query compilation also to come into picture. CHECKPOINT DBCC DROPCLEA...
No comments:
Post a Comment