#composite-primary-key

Fixed Sqlite primary key on multiple columns #dev #it #asnwer

Sqlite primary key on multiple columns

What is the syntax for specifying a primary key on more than 1 column in SQLITE ?

Answer: Sqlite primary key on multiple columns

CREATE TABLE something ( column1 INTEGER NOT NULL, column2 INTEGER NOT NULL, value, PRIMARY KEY ( column1, column2) );

Answer: Sqlite primary key on multiple columns

Yes. But remember that such primary key allow NULLvalues in…

How to: Sqlite primary key on multiple columns

Sqlite primary key on multiple columns

What is the syntax for specifying a primary key on more than 1 column in SQLITE ?

Answer: Sqlite primary key on multiple columns

According to the documentation, it’s

CREATE TABLE something (column1, column2, column3, PRIMARY KEY (column1, column2));

Answer: Sqlite primary key on multiple columns

Yes. But remember that such primary key allow NULLvalues in…