check constraint based on other column

• sbendayan

  SSCommitted

  Points: 1791

  More actions

  August 29, 2002 at 10:07 am

  #105261

  Greetings,

  I am trying to write a check constraint based on the value of another column in the same table. If the other column = 0, then the check constraint should not allow any entries into its field. Any ideas? I'm hoping not to have to use a trigger for this....

• NPeeters

  SSChampion

  Points: 12534

  More actions

  August 30, 2002 at 12:55 am

  #435721

  You'll have to add the check constraint on multiple columns, on table level that is. The next statement should do the trick

  alter table constrainttest

  add constraint two_column CHECK (other_column <> 0 OR field_to_check is null)