Partilhar via


Setting or Changing Field-Level or Table Rules

You can set new field-level or table rule expressions and rule text, as well as alter rules and text you established with CREATE TABLE or ALTER TABLE commands.

To change an existing rule

  • In the Table Designer, select the Table tab and enter the new rule expression or rule text in the Rule and Message boxes in the Record validation section.

    -or-

  • Use the ALTER TABLE command.

To view the current rule expression and associated text, you can use the DBGETPROP( ) function; these values are read-only for tables and can only be changed using the ALTER TABLE command.

See Also

Renaming Fields | Setting or Changing Default Values | Working with Tables | Deleting Fields | Modifying the Table Structure