6 Replies Latest reply: Sep 27, 2006 8:47 AM by RadhakrishnaSarma RSS

    Check constraint

    3004
      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~