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: 299

Filed under:
|
|
|

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

Related posts about c++

Related posts about sql