Database Settings

Databases are customizable, so it is relative easy to add a new database to the known list.
DbSchema Settings per Database

Tip about setting description We don't explain each setting apart. Click the setting and you can read the description in the bottom part of the dialog. Double-click to edit.

Data Type Settings

Here we can edit, add or remove different data types, with their information:

SQL Language

Tables, columns and foreign keys are created and modified using SQL Alter Table commands. They are customizable, so you can fix yourself possible errors. Please inform us as well about incompatibilities. The correct statements can be usually found on the database website or documentation.

On this tab are listed also settings for letter case sensitivity. Many databases does convert table and column names to uppercase or lowercase. MySql uses lowercases, Oracle uppercases. If you want to avoid this you may add quotes to the table or column names. DbSchema converts from the names to uppercase or lowercase directly in the table and column dialog, so you can see them as they will be in the database.

Reverse Engineer Settings

DbSchema trust the JDBC driver to get the table, columns and foreign keys information from the database. We use custom queries only for triggers, procedures and functions, as they are not listed by the JDBC driver. This job is not always easy and the procedures are not always reversed correctly for all databases. Please let us know if you know any fix to this queries. We plan to introduce groovy language for this settings, so we can have a better logic at this level.

This queries are usually returning few standard columns, like schema name, function/trigger/procedure name and source code text.