|
Interactive diagrams
|
Work over multiple layouts ( diagrams )
|
Edit tables, columns, etc. by double-clicking them.
|
Add tables to layout by drag and drop from the Structure tree.
|
Open multiple layouts at a time. A table can be listed in multiple layouts.
|
Show columns data type in layout.
|
Foreign keys can be drawn joined to column - a line may be shared by multiple foreign keys.
|
|
Connect to database
|
Configure database connection using JDBC driver
|
Manage the JDBC drivers and connection Url
|
Start DbSchema project from existing database and decide which schemes to use
|
|
Edit schema online/offline, synchronize schema with the database
|
Editing schema online will apply changes in database and DbSchema, offline only in DbSchema
|
Synchronize the schema with the database
|
Apply commit synchronization actions on the database
|
|
Relational browse database data
|
Browse data from multiple tables. Child tables shows the records related to the parent table.
|
Add parent table to the browse pane by drag and drop from the layout pane.
|
Add child table by pressing the Fk icon.
|
Set filter over one table column.
|
Show one record or multiple table records at a time.
|
Data Browse editor is saved in the project file under the owning layout.
|
|
SQL Editor
|
Open the SQL editor inside a layout
|
Make use of the auto-complete feature
|
Create multiple result panes and increase the result row height.
|
Decide to write the SQL result directly to file.
|
|
Query Builder
|
Edit and execute queries using the Query Builder
|
Choose a different join type
|
Using aggregate functions will generate Group By queries.
|
|
Documentation
|
Comment your schema using comments for each table and column and Callboxes.
|
Generate XHTML web interactive documentation.
|
|
Look and feel
|
Architect look and feel
|
Blue eyes look and feel
|
Different Java Look and Feel
|