no support for multiple primary keys

[branrx]

hi, I've recently started using SQLite studio, and I've noticed that I'm only able to assign a single primary key per table.

[pawelsalawa]

Composite primary keys (for multiple columns) can be added in the bottom panel of structure tab.

[Unsxlved]

I'm also facing the same issue, but I cant seem to be able to make the select a second primary key for my tables. Could you elaborate a little more?

[pawelsalawa]

[Unsxlved]

Yeah i see that but once I already have a column in there with a primary key. It no longer lets me click that button

[pawelsalawa]

Because you cannot define 2 primary keys. You either define one inside a column (and that will be for a single column only), or you do not mark it inside a column, but instead you define it here, at the bottom.

[Unsxlved]

Oh I get it now

Thanks. Your a life saver