3
Reply

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

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

    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.


    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.