Create check clauses in Database Model diagrams

Check clauses enforce constraints on a table or column.

Note: After you reverse engineer a database, the Code window lists all check clauses extracted from the database as local code.

Create a check clause for a column

1. Double-click the table to open the Database Properties window.

2. Under Categories click Columns, and then click the column that you want to add a check clause to.

3. Click Edit.

4. On the Check tab of the Column Properties dialog box, enter the constraints you want.

   For specific help about your choices, press F1 or click the Help button to access Help.

   Note: The check clause is added to the Code window under Local code.

Create a check clause for a table

When you create a new check clause for a table, the code is specific to a database platform. You specify the database by selecting a database driver for your model.

1. Double-click the table to open the Database Properties window.

2. Under Categories click Check, and then click Add.

3. On the Properties tab type a name for the check clause.

4. On the Body tab, type the code and then click OK.

   Note: The check clause is added to the Code window under Local code.