This article provides an example to add constraint in a sc table i.e marks must be between 0 to 100.
altertable sc addconstraint check_sc_marks check(marks between 0 and 100);