Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
|
There are four methods for creating constraints within the ER Modeler. These methods work for Primary Key Constraints, Unique Constraints and Check Constraints. 1. Right clicking on a table entity in the sheet view and selecting "New Unique Constraint" from the context menu. 2. Right clicking on a table node in the the model node browser and selecting "New Unique Constraint" from the menu. 3. Expanding a table entity node in the model node browser, right clicking on the constraints node for that table and selecting "New Unique Constraint". 4. Left clicking on a table entity in the sheet view and choosing Edit->New Unique Constraint from the ER Modeler application menu bar while the table entity is still selected in the sheet. Unique Constraints
Check Constraints
Primary Key Constraints
A constraint may be created by right clicking on the Constraints node within a Table within the Model Browser. The resulting menu allows the selection of New Primary Key Constraint New Unique Constraint and New Check Constraint.
The New Unique Constraint window allows the editing of its Name and designation of which columns are unique with a left click on the right hand column.
The New Check Constraint window allows the the naming of the Check Constraint and its conditions.
|
|