Database Editor is 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.

General

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.

Character Set

This option specifies the default database character set.

Template

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).

Tablespace

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.

Owner

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).

Comments

A comment for the table.

Generate

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

Script

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

Preview

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.

Notes

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