Default database options

This tab helps you to set the parameters, that will be applied as defaults for the newly created tables and generated SQL scripts.

To open this dialog window, please, select Diagram | Diagram Properties and switch to the Default Database Options tab. You can also select Diagram | Default Database Options directly.

There are the following options:

Default Data type

Use this drop-down list to select the data type. This option will be applied as a default data type for the newly created columns.

Foreign Key columns prefix

Sets the prefix, which will be added to the names of new foreign key columns. You can use substitution %TABLENAME%, which will be replaced by the name of the master table.

SQL Delimiter

This option sets the delimiter that will be used on SQL script generation to separate SQL statements. Default PostgreSQL delimiter symbol is ";". We stronlgy recommend do not change this property.

Quoted Character

This option sets the character that will be used on SQL script generation to quote table column names and values. Default PostgreSQL quoted symbol is '"'. We stronlgy recommend do not change this property.

Enclose Names

This option forces quoting of the diagram objects names by a quote character, i.e. it makes "Column" and "Table" instead of Column and Table in SQL script.