SQL Server Composite key
SQL Server Primary key is used to uniquely identify each rows in the table but sometimes more than one column are used to uniquely identify each rows in the table.
Home »
sql composite key
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.