Documentation Home
MySQL Workbench Manual
Related Documentation Download this Manual
PDF (US Ltr) - 16.3Mb
PDF (A4) - 16.3Mb
HTML Download (TGZ) - 14.5Mb
HTML Download (Zip) - 14.6Mb MySQL-Specific Validation

The following list names the MySQL-specific validation types and gives examples of specific violations:

  • Integrity Violation

    • An object name longer than the maximum permitted

    • A foreign key defined for an engine type that does not support foreign keys (not yet implemented)

    • A view or routine that references a nonexistent table (not yet implemented)

    • A default value that does not match a column's data type

    • An invalid partitioning scheme

  • Syntax Violation

    • A routine, trigger, or view with incorrect SQL syntax

    • A reserved keyword used as an identifier

    • Use of an invalid character