Create a primary key on two columns

Question

I use the SQLite GUI browser to work with the database. I cannot find a button to make a primary key on two or more columns. How to do it?

Answer 1

SQLite does not support adding constraints.

You need to create a new table, specifying its entire column structure and import the old data into the new table. Then rename the new one after you drop the old one.