SQL multiple column unique

Question

I have a table with the following columns: ID, text1, text2.

What to do in order to make (text1,text2) unique, for example: values (1,a,b), (2,b,b), (3,a,a) are allowed, but (4,a,b) will not be inserted because (a,b) is repeating?

@user3162968 What are you using MySql or SQL server. You can create a composite key on the two column — DhruvJoshi, Feb 14 '14 at 12:08
SQL server. Dhruvjoshi, I would give +2 instead of +1 iff I could, thanks :) — user3162968, Feb 14 '14 at 12:11

score 1 · Accepted Answer · answered Feb 14 '14 at 13:04

1

You can have a unique composite key:

ALTER TABLE my_table
ADD CONSTRAINT uc_my_table UNIQUE (id, text1, text2)

answered Feb 14 '14 at 13:04

Mureinik

277,661
50
283
320

SQL multiple column unique

1 Answers1