What is the syntax for specifying a primary key on more than 1 column in SQLITE ?
9 s
According to the documentation, it’s
CREATE TABLE something (
column1,
column2,
column3,
PRIMARY KEY (column1, column2)
);