|
To define a table constraint:
| 1. | From the menu bar, choose Define, Constraints, Table. |
| The Constraints window appears. |
| You can alternatively use a wizard. Right-mouse-click on Constraints in the Project Catalog, and choose New Restrictive Constraint. |
| 2. | Enter the requested information. (See the What's This? help for more details.) |
| As a minimum, you must enter a Constraint Name and a (SQL) Statement. For restrictive constraints, ie., if the Statement starts with the SELECT keyword, make sure you also enter a Message. |
| TIP: You can add comments on the Comment tab page. You can also include comments in the SQL statements of your constraints. The syntax to use is: |
/* comments */
| 3. | Click the Check button to check your constraint. |
|
