By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table a (a int, b char, key(a,b))
{ "code": "SQLITE_ERROR" }
create table b (a int, b char, unique (a,b))
✓
create table c (a int, b char, primary key(a,b))
✓