Post reply

check constraint based on other column

  • 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)

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply