----------  Create or Drop Range Check  ----------

Data validation checks may be created using the "create range check"  command,
and  removed using the "drop range check" command. The attribute checks can be
for single values, a range of values, less than or greater than a value,  pat-
tern matching, or a combination of these checks.

Syntax:

     create | range check | [on] TABLE.ATTR_NAME | [set] RANGE {, RANGE} |;
            | range       |                      | ( RANGE {, RANGE} )   |

RANGE may indicate the following:

    [is] | VALUE                                                 |
         | OPERATOR VALUE                                        |
         | MATCH_OPERATOR PATTERN                                |
         | like PATTERN                                          |
         | between VALUE [|exclusive|] [and] VALUE [|exclusive|] |
         |                |inclusive|               |inclusive|  |
         | range VALUE [|exclusive|] [to] VALUE [|exclusive|]    |
         |              |inclusive|              |inclusive|     |

OPERATOR is one of:  =, !=, <, >, <=, >=.

MATCH_OPERATOR is one of: match, !match, smatch, !smatch.

PATTERN is defined in the help file on the "where clause".

Note that when specifying TABLE.ATTR_NAME, the attribute must be qualified  by
its table name.

For further information, enter:

                help where_clause;

To remove validation checks currently in place  on  an  attribute,  the  "drop
range check" command is used.

Syntax:

     drop | range check | [on] TABLE.ATTR_NAME;
          | range       |
