3
Reply

What's the difference between a primary key and a unique key?

Purushottam Rathore

Purushottam Rathore

Jul 29, 2009
6.6k
0

    Primary Doesn't allow any dublicate value and null value. But unique allow only one null value. simple and easy

    Ramprit Sahani
    January 30, 2015
    0

    Hi,

    You can have multiple unique keys in a table but can have only one Primary Key.
    Primary key and unique key does not allow enter duplicate data.Primary key doesn't allow null value.Unique key allows only one null value.


    Pradeep
    August 18, 2009
    0

    Both primary key and unique enforce uniqueness of the column on which
    they are defined. But by default primary key creates a clustered index
    on the column, where are unique creates a nonclustered index by
    default. Another major difference is that, primary key doesn't allow
    NULLs, but unique key allows one NULL only.

    Purushottam Rathore
    July 29, 2009
    0