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.
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.
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.
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).
Collate
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.
CType
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.
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.
See also:
Diagram Objects: Database