Database Editor

Top Previous Next

Database Editor helps you to set up a virtual diagram object - a database. This object can be used during database generation. To open Database Editor select Diagram | Database Editor menu item.

Database Editor contains several tabs, please see the detailed description below.



This tab allows you to set the name of the database and other basic parameters.

Database Name

Use this field to set the database name.

Connection Limit

How many concurrent connections can be made to this database; -1 (the default) means no limit.

Character Set

This option specifies the default database character set.


The Template parameter contains the name of the template you want to base your new database of. Use the DEFAULT keyword to specify the default template (usually template1).


The Tablespace parameter contains the name of a tablespace. A tablespace allows you to define an alternative location on the file system where the data files containing database objects (such as tables and indexes) may reside. You can manage tablespaces using SQL commands such as CREATE TABLESPACE and ALTER TABLESPACE.


The name of the database user who will own the new database, type DEFAULT to use the default user name (namely, the user executing the command).


Collation order (LC_COLLATE) to use in the new database. This affects the sort order applied to strings, e.g. in queries with ORDER BY, as well as the order used in indexes on text columns. The default is to use the collation order of the template database. See below for additional restrictions.


Character classification (LC_CTYPE) to use in the new database. This affects the categorization of characters, e.g. lower, upper and digit. The default is to use the character classification of the template database. See below for additional restrictions.


A comment for the table.


Set this option off to disable generation of the physical database. The database objects will be generated in compliance with their own properties.


This tab allows you to set SQL statements, which will be executed before (use Begin tab) and after (use End tab) generation of database.


The Preview tab displays the SQL statement, which will be executed during the database generation. This statement is made up according to the changes you have made using the previous tabs. Please note, that the text within the editor is read-only. The contents of this tab will be updated only when your press Apply button.


The Note tab allows you to define the description and annotation for the edited database.

See also:
Diagram Objects: Database