COMPOSITE KEY

---

COMPOSITE KEY in SQL Server Database 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.

It may be a candidate key or primary key.

Sometimes more than one attributes are needed to uniquely identify an entity.

Syntax

CREATE TABLE TABLE_NAME  
(COLUMN_1, DATA_TYPE_1,  
COLUMN_2, DATA_TYPE_2,  
???  
PRIMARY KEY (COLUMN_1, COLUMN_2, ...));