In SQLite my composite key PK_SOME_LKUP fails to create when I ALTER the table. My table creates, but my composite key creation fails. Any idea what the syntax should be?

TABLE CREATE - PASS

create table SOME_TABLE(KEY_1 text not null, KEY_2 text not null )

COMPOSITE PRIMARY KEY - FAIL

alter table SOME_TABLE add constraint PK_SOME_LKUP primary key (KEY_1,KEY_2);

Thanks!
gilgantic

Hi gilgantic,

why not to remove and re-create the table?