Altova DatabaseSpy 2023 Enterprise Edition

Check constraints are used to validate data accepted by a column. They provide an expression that must be satisfied before data can be inserted successfully. Check constraints can be defined on table level (that is, several columns of a table are checked in the expression) or on a single column. Multiple check constraints can be applied to a single column.

 

In the Online Browser, check constraints appear in the "Check Constraints" folder of a table, and are shown with the dbs_ic_check_constraint icon.

dbs_check_constraint_04

When you select a check constraint, the expression used by it is displayed in the Default property in the Properties window.

 

In the Design Editor, the expression is displayed in the "Expression" column of the "Check Constraint" section of a table design.

dbs_check_constraint_05

See also Creating Check Constraints, Editing Check Constraints and Dropping Check Constraints.

© 2017-2023 Altova GmbH