Question d’entretien chez Kevit Technologies

difference between primary key and unique key ?

Réponse à la question d'entretien

Utilisateur anonyme

20 sept. 2019

Primary key will not accept NULL values whereas Unique key can accept one NULL value. A table can have only primary key whereas there can be multiple unique key on a table. A Clustered index automatically created when a primary key is defined whereas Unique key generates the non-clustered index.