Online Documentation for SQL Manager for MySQL

Editing check definition

Check Editor allows you to specify check definition and set check properties. It opens automatically when you create a new check and is available on editing an existing one (see Create check and Edit check for details).

To open a check constraint in Check Editor, double-click it in the DB Explorer tree, or use the Edit Check... item of the context menu within the Checks tab of Table Editor.

Check name

Enter a name for the new check, or modify the name of the check being edited.

Expression

A Boolean expression evaluated for each row when data is inserted or updated.

Enforced

If selected, the server enforces the constraint. If cleared, the constraint is stored but not checked.