|
|
Note: To generate the table, column descriptions for SQL Server db in Toad Data Modeler, schema/owner has to be defined. Please see the Entity Properties form | General tab and from the Schema box select a schema or click the icon on the right to open the Schema dialog and define a new schema, then select it for the entity. |
For Row Format item, it's possible to select some of these options:
Properties Character Set and Collation must be identical for parent and child tables provided that at least one parent attribute is of a text data type. If the properties are not identical, a warning message is returned during model verification.
On the Partition Options tab, you can write SQL code to create partition. The partition will be generated in SQL code as well as in reports.
See the SQL Preview tab:
Comments box on tab General - The text written in the Comments box on entities and attributes is generated in final DDL script.
MySQL Enum data type is converted to Char data type, a check constraint for the attribute is created, the parameter is preserved (see the SQL tab of the Check Constraint Properties dialog).
Foreign keys are supported only by tables of the InnoDB type.
The following types of indexes are supported:
Fulltext indexes are supported only by tables of type MyISAM.
Trigger Event options:
Trigger Time options:
In MySQL 5, User Data Types and Dictionary types are not available.
See Reverse Engineering - MySQL 8.0 for more information.
See Script Generation - MySQL 8.0 for more information.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
