This discussion is archived
6 Replies Latest reply: Sep 27, 2006 6:47 AM by RadhakrishnaSarma RSS

Check constraint

3004 Newbie
Currently Being Moderated
I want to add a check constraint in this scenrio...
(testTable)
A B
------
1 1
2 2
3 1

I want to restrict that allow...
insert into testTable (A,B) = (3,2);
insert into testTable (A,B) = (3,3);

but not allow...
insert into testTable (A,B) = (3,1);

How can I do that?

Thank you~