create a table in sql server management studio with composite primary key code example
Example: how to define a composite primary key in sql
CREATE TABLE person(id INT,
name TEXT,
PRIMARY KEY (id, name)
);
CREATE TABLE person(id INT,
name TEXT,
PRIMARY KEY (id, name)
);