SQL Server Education (by the geeks, for the geeks)
Both enforces uniqueness of the column. When we define an Unique constraint, SQL server creates an unique index (Unique non clustered index) on the column where Unique constraint is defined. Even though …
SQL Server– Unique Constraint VS Unique Index Read MoreTo start with there is no practical difference between Unique Index and unique constraint; they both accomplish the task of providing uniqueness to a column. A unique constraint is enforced by …
Unique index vs unique constraint in SQL Server Read MoreA unique index guarantees that the index key contains no duplicate values and therefore every row in the table is in some way unique. Specifying a unique index makes sense only …
SQL Server Unique Constraint Multiple Null Values Read More