How Can I Define the MySQL Table Type?

You can define the MySQL table type in the table options field. This field can be found in the "general" tab of the Entity dialog. Table options will be included at the end of a Create statement. You can fill this field for example with "TYPE = MYISAM".

CREATE TABLE TESTTABLE 
( 
COL1 VARCHAR(12), 
COL2 VARCHAR(12) 
) 
<--This the place were the table options will
appear in the generated SQL. Before the statement
terminator --> 
;

define mysql table options such as type=innodb

Default table options

Default table options define table options for an entire project. When default table options have been defined for a project, any new entity you create takes the default table option values.

You can define default table options in the General sheet of the Project Options dialog.

You can apply the (new) default table options to all entities by clicking Apply to All Entities in the Project Options dailog. You can find the Apply to All Entities button right under the Default Table Options entry field.

See also: How can I define my storage parameters?

Back to Knowledge Base DeZign for Databases