Skip navigation links

MySQL Forums


Advanced Search

UNIQUE Constraints in Microsoft SQL Server
Posted by: merrcy merrcy ()
Date: November 07, 2009 03:37AM

UNIQUE Constraints in Microsoft SQL Server
UNIQUE constraints allow SQL Server administrators to specify that a column may not contain duplicate values. When you create a new UNIQUE constraint, SQL Server checks the column in question to determine whether it contains any duplicate values. If the table contains preexisting duplicates, the constraint creation command fails. Similarly, once you have a UNIQUE constraint on a column, attempts to add or modify data that would cause duplicates to exist also fail.

Buildings and Contents Insurance
Get Cash Online

Options: ReplyQuote


Subject Written By Posted
UNIQUE Constraints in Microsoft SQL Server merrcy merrcy 11/07/2009 03:37AM


Sorry, only registered users may post in this forum.