ERD Features
Color coding of database tables and foreign keys
Add foriegn keys with a single click
Column templates make adding common columns easy
Generate HTML documentation of database designs
Forward Engineering
Create & update SQL DDL scripts take into account DBMS-specific commands
Update scripts generated based on current server database schema
Can select to execute only portions of SQL scripts
Supports transactions
Generates a log of forward engineering results and any errors
Reverse Engineering
Reverse engineer existing databases
Reverse synchronize database changes back into designs
Translate database schema from one DBMS to another
Full round-trip engineering including generating update scripts
Multiple Vendor Compatibilty
Currently supports Microsoft SQL Server, PostgreSQL and MySQL
Multiple operating system support including Windows, Linux and Mac
Query Editor
Syntax highlighting editor
Create abbreviations for common commands and entity names
Execute multiple queries simultaneously
Display query results in tables or as text
Sort result sets by clicking on table headers
Translate common proprietary DBMS commands to another DBMS
Support for most common PSQL commands
