How to: Remove Validation Rules
If you no longer want to use a field or record validation rule, you can remove it.
Note
Validation rules are stored in the database (.dbc) file. Removing or deleting a database table removes and deletes all field and record validation rules associated with that table. However, stored procedures referenced by the removed or deleted validation rules remain.
To remove a field validation rule
Open the database containing the table.
Open the table in the Table Designer.
In the Table Designer, select the field you want.
In the Rule box from the Field validation area, delete the validation expression.
In the Message box, delete the custom error message or expression.
When you are finished, click OK.
For more information, see Fields Tab, Table Designer.
To remove a record validation rule
Open the database containing the table.
Open the table in the Table Designer.
In the Table Designer, click the Table tab.
In the Rule box from the Record validation area, delete the validation expression.
In the Message box, delete the custom error message or expression.
When you are finished, click OK.
For more information, see Table Tab, Table Designer.
To remove a validation rule programmatically
Open the table with the USE command.
Use the SQL ALTER TABLE command with the DROP CHECK clause.
For more information, see ALTER TABLE - SQL Command.