Suresh Paldia
Is UNIQUE+NOT NULL equivalent to PRIMARY KEY in all respects? OR just the properties are same?
By Suresh Paldia in SQL on Nov 01 2010
  • Sanjeev Kumar
    Jul, 2016 19

    Alternative key or secondary key is combination of unique key +not null

    • 0
  • Rahul Prajapat
    May, 2015 30

    No both are not same . It is true that Unique+Not null and Primary Key allow same restrictions on data but there is a diff that column with primary key contain a Clustered index but column with Unique Key+Null Contain a Non-Clustered index.

    • 0
  • Pankaj  Kumar Choudhary
    May, 2015 21

    No both are not same . It is true that Unique+Not null and Primary Key allow same restrictions on data but there is a diff that column with primary key contain a Clustered index but column with Unique Key+Null Contain a Non-Clustered index.....

    • 0
  • Harshit Vyas
    Nov, 2010 15

    yes they are totally equal

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS