Arjun Kumar
Explain the difference between UNIQUE constraint and PRIMARY KEY constraint in SQL Server?
By Arjun Kumar in SQL Server on Jul 06 2012
  • Amresh  Bahadur Singh
    May, 2014 23

    A table can have only one primary key, but many unique columns. And Primary key is not allow any null value while Unique key one null values allow.

    • 0
  • Akkiraju Ivaturi
    Aug, 2012 5

    Unique constraint makes the column to hold only unique values. It may include null value too. Any column which is unique cannot be used for references with other table unless it is a primary key. Primary key is clustered index and it does not support null values. A table can have only one primary key, but many unique columns.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS