Skip to content
Home » difference between primarykey and composite key in sql

difference between primarykey and composite key in sql

Primary Key VS Composite Key?

A PRIMARY KEY constraint uniquely identifies each record in a table .

A COMPOSITE KEY is a combination of two or more columns in a table that can be used to uniquely identify each row in the table when the columns are combined uniqueness is guaranteed, but when it taken individually it does not guarantee uniqueness.

Loading