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.
Available Data Providers are:
Connection via TCP/IP:
Connection via ODBC
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.
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.