Tag Archives: Primary key in sql

Difference between Primary, Unique, Candidate and Composite Keys

Primary key: Primary key is a key that is used for uniquely identify the each rows in a table. A primary key cannot be null and cannot be more than one primary key in a table. Where we create a primary key a cluster index is created. But we can change it with non- cluster… Read More »