Composite key in SQLite

Question

How to put a composite key in SQLite? In SQL Server, we select multiple columns and then Set Primary Key. What is the method in SQLite?

I'm using SQLite Database Browser to manage my DB structure, I don't find the option for putting a composite key in a table or maybe I'm missing something. Will some one help me out with this?

Answer 1

Put a PRIMARY KEY (col1, col2, col3) constraint in the CREATE TABLE statement. SQLite doesn't support changing a table's primary key after it's created (which is a bit of a silly idea anyway).