Design Features
Use column templates to add common columns quickly and easily
Generate HTML documentation of database designs
Quickly name and enforce naming conventions with Auto Naming
Add a foriegn key with just a few clicks
^Top
Forward Engineering
Update DDL scripts generated based on differences between design and server databases
Execute only select parts of scripts
Support for transactions
Reverse Engineering
Reverse engineer existing databases
Insert and update table data with automatically generated forms, which provide entry time data validation and combo box entry for foreign key fields
Reverse synchronize server database changes into designs
Diagraming Features
Navigator window to easily navigate diagrams
Multiple foreign key link algorithms
Selecting a foreign key highlights the columns used in that foreign key
SQL Editor
Syntax highlighting editor
Code completion
Create abbreviations for common commands and entity names
Display query results in tables or as text
Multiple Vendor Compatibilty
Currently supports Microsoft SQL Server, PostgreSQL and MySQL
Multiple operating system support including Windows, Linux and Mac