Constraints Node

This section covers the following topics:

About Constraints

Constraints are rules that you create to restrict values in a database. You can define one or more conditions in the constraint that a user must satisfy before they make changes to the table to which you have applied the constraint. They are part of the table definition and operate automatically.

How the Constraints Node Works

The Constraints node, which is a child of the Tables node, contains one or more child Constraint nodes for a table. To perform actions on the Constraints node: right-click the node and from the menu, choose the appropriate command. To view the node's properties, select the node and/or click Properties in the node's menu.

If this collection node is filtered, the icon changes to include a funnel symbol. For more information about filtering, see Filtering Collection Nodes.

Menu Options

Menu Option Description

Design Table

Edits the table using the Table Designer.

Refresh

Updates the Constraints node, including its associated constraints nodes.

Properties

Displays the Properties window.