- 7.1.5 The Model Menu
- 7.1.5.1 The DBDoc Model Reporting Dialog Window (Commercial Version)
- 7.1.5.2 The Validation Menu Options (Commercial Version)
- 7.1.5.3 The Object Notation Menu Options
- 7.1.5.4 The Relationship Notation Menu Option
Under the Model menu option there are two validation options, Validation and Validation (MySQL). Use these options for general validation and MySQL-specific validation of the objects and relationships defined in your model.
Note
These options are not available in the MySQL Workbench OSS version.
Under the Validation option the menu items are:
Validate All – Perform all the validation options available
Empty Content Validation – Check for objects with no content, for example a table with no columns
Table Efficiency Validation – Check the efficiency of tables, for example a table with no primary key defined
Duplicate Identifiers Validation – Check for duplicate identifiers, for example two tables with the same name
Consistency Validation – Check for consistent naming conventions
Logic Validation – Check, for example, that a foreign key does not reference a nonprimary key column in the source table
Under the Validation (MySQL) option the menu items are:
Validate All – Perform all the validation options available
Integrity Validation – Check for invalid references, for example, a table name longer than the maximum allowed
Syntax validation – Check for correct SQL syntax
Duplicate Identifiers Validation (Additions) – Check for objects with the same name
For detailed information about validation see Section 7.8, “MySQL Workbench Schema Validation Plugins (Commercial Version)”.
