Sqlite primary key on multiple columns

sqlite primary-key ddl composite-primary-key

Bogdan Gavril MSFT · Apr 9, 2009 · Viewed 274.8k times · Source

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

Answer

According to the documentation, it's

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