SQLEditor Icon

Defaults Preferences

The options on the Defaults preference tab change the settings that are used by new documents. The options match those available in the View menu

See also The View Menu

Show Page Grid

Draws a grid behind the objects for alignment purposes

Snap to Grid

The position of objects will be aligned (or snapped) to the intersections of the grid

Show Page Boundaries

Display lines showing approximate edges of printed pages if the document were printed using current settings

Show Source Sidebar

This option causes SQLEditor to make the source sidebar visible when a new document is opened.

If this option is disabled, the source sidebar can still be made visible after the document has been created.

Show Field Types

Display field types (e.g. VARCHAR, INT) in tables when displayed. This only affects display of the fields, the underlying types are still specified.

This option is mainly to simply display of complicated diagrams where the simplicity of not displaying types is traded off against the total amount of information displayed

Show Field Icons

Display icons for field information (e.g. P for PRIMARY KEY, U for UNSIGNED, etc) This only affects display, the underlying data is unaffected

This option is mainly to simply display of complicated diagrams where the simplicity of not displaying field icons is traded off against the total amount of information displayed

Auto size tables

SQLEditor will resize tables so that the whole width of the name and all of the content in the fields contained in the table are visible

Prefix index name with table name

When creating a new index, add the name of the table to the new index name

This helps to create indexes with unique names

Set indexed on fields where possible

If enabled, when importing, SQLEditor will try to set the indexed property on fields rather than creating a new index object in the table.

Foreign Key Cardinality

This option specifies the default cardinality settings for newly created foreign keys that are manually created by you

Default Import Cardinality

This option specifies the default cardinality settings for newly created foreign keys that are created by SQLEditor when it imports a foreign key from a database or via the SQL parser