[sqlite] best way to have a constraint over 2 fields

Hi all, I have a question about the best way to have a constrain on a table. think to a DB with 2 fields in the table ColA and ColB and you don't want to have multiple records with the same ColA,ColB couple so we can CONSTRAINT ColA_ColB UNIQUE (ColA,ColB) in the create table or CREATE UNIQUE

[sqlite] best way to have a constraint over 2 fields

at mailinglists.sqlite.org Betreff: [sqlite] best way to have a constraint over 2 fields Hi all, I have a question about the best way to have a constrain on a table. think to a DB with 2 fields in the table ColA and ColB and you don't want to have multiple records with the same ColA,ColB couple so we