Top "Unique-constraint" questions

Unique-constraint is an index that sets one or multiple fields to be unique in a data entity

How to do multiple column unique-constraint in ormlite ( SQLite )

I'm using ormlite for Android and I'm trying to get a multiple column unique-constraint. As of now i'm only able …

sql sqlite unique-constraint ormlite
Can I conditionally enforce a uniqueness constraint?

My database contains a table of users. Every active user has a unique username. I'd like to be able to …

mysql unique-constraint
Postgres UNIQUE CONSTRAINT for array

How to create a constraint on the uniqueness of all the values ​​in the array like: CREATE TABLE mytable ( interface …

arrays postgresql unique-constraint
How to get existing record on a unique key violation

when performing an insert I get the following error message AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE INDEX IN …

db2 unique-constraint rowid
PostgreSQL multiple nullable columns in unique constraint

We have a legacy database schema that has some interesting design decisions. Until recently, we have only supported Oracle and …

sql postgresql database-design null unique-constraint
Composite Unique Constraint SQL

I have a table with parents and children, each record has a PRIMARY KEY id, a 'name', and a 'parent' …

sql unique-constraint