Check Constraint Rules

To add a check constraint rule 

Select Model | Model Items |Check Constraint Rules and click Add in the Check Constraint Rules  dialog.

To edit a check constraint rule

Select Model | Model Items |Check Constraint Rules and double-click the selected check constraint rule or click Edit.

Note: You can also edit/rename/delete check constraint rules in Model Explorer | Check ConstraintRules folder | Right-click the selected check constraint rule.

To assign a check constraint rule to attribute

1. Edit attribute and click the Check Constraints tab.
2. Add a new check constraint, confirm Apply and click Edit to open its Properties dialog.
3. In the Check Constraint Rule box, select a rule for the attribute.

Schemas

Toad Data Modeler allows you to design Entity Relationship Diagrams of specific database platforms, convert physical model from one database platform to another, create an ER Diagram directly from your database (Reverse Engineering feature), update physical models, generate DDL/SQL scripts and Change Scripts, create Dictionary Types, Views, Triggers, Functions, generate detailed documentation to your model (in HTML, RTF, PDF, XSLT formats) and much more.

This chapter describes features and functions related to Physical Data Modeling. Look around each section to get the information you need.

Benefits of Physical Data Model

• Detailed definition of database structure, including database specific items, for example:
  • Stored procedures
  • Functions
  • Triggers
  • Views
  • Materialized views
  • Sequences (auto increments) etc.
• Possibility to synchronize local model with existing database.
• Possibility to specify logical names for objects (captions for tables, attributes and other objects).
• Detailed database specific information can be exported to HTML/RTF/PDF or XML/XHTML/CSV reports.
• Automatic generation of SQL code for selected objects (SQL code generation is not available in Logical and Universal Model)
• Automatic migration of PK attributes to child entities (Attributes don't migrate to child entities in Logical Model)

Schemas

To add a schema

Select Model | Model Items |Schemas and click Add in the Schemas dialog.

To edit a schema

Select Model |Model Items | Schemasand double-click the selected schema or click Edit.

Synonyms

Toad Data Modeler allows you to design Entity Relationship Diagrams of specific database platforms, convert physical model from one database platform to another, create an ER Diagram directly from your database (Reverse Engineering feature), update physical models, generate DDL/SQL scripts and Change Scripts, create Dictionary Types, Views, Triggers, Functions, generate detailed documentation to your model (in HTML, RTF, PDF, XSLT formats) and much more.

This chapter describes features and functions related to Physical Data Modeling. Look around each section to get the information you need.

Benefits of Physical Data Model

• Detailed definition of database structure, including database specific items, for example:
  • Stored procedures
  • Functions
  • Triggers
  • Views
  • Materialized views
  • Sequences (auto increments) etc.
• Possibility to synchronize local model with existing database.
• Possibility to specify logical names for objects (captions for tables, attributes and other objects).
• Detailed database specific information can be exported to HTML/RTF/PDF or XML/XHTML/CSV reports.
• Automatic generation of SQL code for selected objects (SQL code generation is not available in Logical and Universal Model)
• Automatic migration of PK attributes to child entities (Attributes don't migrate to child entities in Logical Model)