In the following example, the SHOW FIELD statement shows the SEX field, which contains a VALID IF clause. The CHANGE FIELD statement removes the VALID_IF clause from the SEX field: RDO> DATA FILE DB$:PERSONNEL RDO> SHOW FIELD SEX SEX text size is 1 Description: M, F Missing value: "?" Valid: IF SEX = 'M' OR SEX = 'F' OR SEX MISSING RDO> CHANGE FIELD SEX NO VALID IF. RDO> SHOW FIELD SEX SEX text size is 1 Description: M, F Missing value: "?" RDO> ROLLBACK