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", "New Primary Key Constraint" or "New Check Constraint" from the context menu. 2. Right clicking on a table node in the the model node browser and selecting "New Unique Constraint", "New Primary Key Constraint" or "New Check 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", "New Primary Key Constraint" or "New Check Constraint". 4. Left clicking on a table entity in the sheet view and choosing Edit->New Unique Constraint, "New Primary Key Constraint" or "New Check Constraint" from the ER Modeler application menu bar while the table entity is still selected in the sheet. Unique Constraints When the New Unique Constraint properties window appears, The Unique Constraint must be named. Its table, database and schema display based on the table's corresponding information. The column names on the left can be clicked to select them for participation in the constraint. Their constraint type "Unique" is indicated in the constraint column and the sequence in which they are clicked determines their order number in the Sequence column. Check Constraints
Primary Key Constraints
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.
|
|