Support
How can we help you today?

How Can I Define My Storage Parameters?

The table storage parameters (and additional table properties) can be defined in the table options. 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.

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 --> 
; 

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 the MySQL table type?