4
Reply

Is UNIQUE+NOT NULL equivalent to PRIMARY KEY in all respects? OR just the properties are same?

Suresh Paldia

Suresh Paldia
15y
4.2k
0
Reply
    Sanjeev Kumar
    Alternative key or secondary key is combination of unique key +not null
    Sanjeev Kumar
    9y
    0
    Rahul Prajapat
    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.
    Rahul Prajapat
    10y
    0
    Pankaj Kumar Choudhary
    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.....
    Pankaj Kumar Choudhary
    10y
    0
    Harshit Vyas
    yes they are totally equal
    Harshit Vyas
    15y
    0
Message