js editor
Web development
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.