COMPOSITE KEY

Works the same as primary key, but it works on multiple columns.

CREATE TABLE SchameName.TableName(
	ColName1 smallint IDENTITY(1,1) NOT NULL,
	ColName2 VARCHAR(50) UNIQUE,
	CONSTRAINT pk_ColName1 PRIMARY KEY (ColName1, ColName2)
)