primary key as composite key sql create table 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)
);