How to set two column unique in SQL.
Posted
by sxingfeng
on Stack Overflow
See other posts from Stack Overflow
or by sxingfeng
Published on 2010-06-17T07:59:01Z
Indexed on
2010/06/17
8:03 UTC
Read the original article
Hit count: 296
I am creating a table ,in the table two column is unique, I mean columnA and columnB do not have same value: such as :
Table X
A B
1 2(RIGHT,unique)
2 2(RIGHT, unique)
1 3(RIGHT, not unique)
2 3(RIGHT, not unique)
1 2 (WRONG, not unique)
How to create such a table? many thanks!
© Stack Overflow or respective owner