SQLite Forum

3.31.1: create table with multiple primary key columns
Login
You can have either deferred or immediate. You don't have any commands to change that once the table's made though.
<https://www.sqlite.org/foreignkeys.html#fk_deferred>