MySQL Support

Top  Previous  Next

Here is a partial list of the MySQL-specific objects and properties that are supported in ModelRight 4.0.  ModelRight 4.0 can Reverse Engineer, Forward Engineer (Generate SQL DDL), and Compare these objects and properties with an existing database or other Model.

Tables - Partitioning, Sub-Partitioning, MySQL-specific Physical Properties - like Engine, Row Format, Auto Increment, Key Block Size, etc...

Columns - IDENTITY, Not for Replication, Enum and Set

Views - MySQL-specific properties like: Security Type, Algorithm, Definer, etc...

Indexes -MySQL-specific Physical Properties - like Full Text

Key Constraints

Collation

Character Sets

Engines

Logfile Groups

Database

Tablespaces, Datafiles, and their MySQL-specific properties

Template support for many of the above object types

Partition Functions and S