Working with Data Models › Forward Engineer/Alter Script › Model Validation Check

Model Validation Check

The following generic check model validation routines are implemented for most databases (some are database dependent):

• Tables without any columns, without any indexes, without any primary key columns, or has more than 128 indexes
• Indexes without any columns, having more than 15 columns, redundent
• Columns which refer to undefined datatypes, whose FK datatypes differ from the migrating parent PK datatype
• Keyword violations
• Use of invalid characters
• Invalid length of table name, index name, column name, constraint name, validation rule name, or default value name (based on database or user-defined restrictions)

More information:

Check Your Model/Validate SQL

Validation Criteria for Oracle Models

Validation Criteria for SQL Server 2005 Models

Validation Criteria for Teradata Models