Table Options


Table Options are used to specify create options for a table. When DbWrench generates forward engineer scripts to create a table it will append table options to the CREATE TABLE step. This only applies to DBMSs that support table options.

Specifying Table Options:

Table options are specified using the Tables data grid in Database Explorer.


Specifying Table Options in Database Explorer

Select the Tables node in the left hand tree. This will display the Tables data grid in the lower right corner.

Edit the Table Options column directly to specify table options.

NOTE: Table comments should be added in the Comment column not in Table Options.

NOTE: For MySQL databases, if no TYPE or ENGINE is specified and the table in used in a foreign key relationship, DbWrench forward engineer scripts will automatically use the InnoDb table option..

Specifying Default Table Options:

Table option defaults are specified at the database level. These options will be automatically applied to new tables.


Specifying Default Table Options

Select the Database node in the left hand node tree of Database Explorer. This will display the Database Properties panel in the lower right corner.

Use the Default Table Options field to set the default table options for this database.

NOTE: the default table options can be overridden on a per table basis using the previous Specifying Table Options procedure.


See also:

Creating Tables