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?

then why didn't you put any information in your question about what you tried and what the error was? — hobbs, Nov 09 '12 at 20:13
Does this answer your question? [Sqlite primary key on multiple columns](https://stackoverflow.com/questions/734689/sqlite-primary-key-on-multiple-columns) — Pedram, Jul 03 '23 at 08:18

score 10 · Accepted Answer · answered Nov 09 '12 at 20:07

10

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).

answered Nov 09 '12 at 20:07

hobbs

223,387
19
210
288

1

it's not that silly if you ponder the point of having a composite primary key in the first place – DarkOhms Apr 24 '22 at 22:15

Composite key in SQLite

1 Answers1