| Function |
Free |
Standard |
Pro |
| Databases |
|
|
|
| ODBC-/BDE-Datasources |
+ |
+ |
+ |
| Paradox- & xBase-Databases |
+ |
+ |
+ |
| ADO support |
- |
+ |
+ |
| MySQL, MS-SQL, InterBase, Oracle, Gupta SQLBase |
- |
+ |
+ |
| PostgreSQL, DB2, Sybase, Informix |
- |
V 1.4 |
+ |
| Views & Systemtables |
- |
+ |
+ |
| Trigger, Stored Procedures and other database objects |
- |
- |
+ |
| User-Management |
- |
- |
+ |
| Data-Dictionary |
- |
- |
+ |
| ER-Diagrams |
- |
- |
+ |
| Tables |
|
|
|
| Database explorer with overview of metadata like connection/driver parameter, tables, views, fields, fieldtypes, fieldsize, indices, primary keys |
+ |
+ |
+ |
| Copying, editing and appending records |
+ |
+ |
+ |
| Record editor |
+ |
+ |
+ |
| BLOB editor for memo-, image- and hex-format |
+ |
+ |
+ |
| Printing table structure |
+ |
+ |
+ |
| Searching and filtering |
+ |
+ |
+ |
| Search and replace for field values |
- |
+ |
+ |
| Sorting |
- |
+ |
+ |
| Report generator with export in PDF, HTML, RTF and more |
- |
+ |
+ |
| Data export in various formats (XML, HTML, SQL script, xBase, CSV etc.) |
- |
+ |
+ |
| Quick export of table data (SQL script & xBase) |
- |
+ |
+ |
| Quick import of table data (SQL script & xBase) |
- |
+ |
+ |
| Empty, pack and reindex |
- |
+ |
+ |
| Dropping of tables, columns, indices, primary keys |
- |
+ |
+ |
| Userdefined views |
- |
- |
+ |
| Master-Detail views |
- |
- |
+ |
| Extended export functions |
- |
- |
+ |
| Extended report functions |
- |
- |
+ |
| SQL |
|
|
|
| SQL editor with syntax highlighting |
+ |
+ |
+ |
| Search/Replace within editor |
+ |
+ |
+ |
| SQL-Script history |
+ |
+ |
+ |
| Searching and filtering |
+ |
+ |
+ |
| Report generator with export in PDF, HTML, RTF and more |
- |
+ |
+ |
| Data export in various formats (XML, HTML, SQL script, xBase, CSV etc.) |
- |
+ |
+ |
| Query builder for SELECT, INSERT, UPDATE & DELETE |
- |
+ |
+ |
| Simple compilation of SELECT statements via Drag & Drop |
- |
+ |
+ |
| Batch mode for execution of multiple SQL statements |
- |
+ |
+ |
| Parametered SQL queries |
- |
+ |
+ |
| automatic code completion |
- |
+ |
+ |
| Adding of tables, columns and indices |
- |
+ |
+ |
| File explorer |
- |
+ |
+ |
| SQL-Code-Manager |
- |
- |
+ |
| Other |
|
|
|
| Error- and message logging |
+ |
+ |
+ |
| Creation of components and source code for Borland Delphi and Borland C++ Builder |
- |
V 1.4 |
+ |
| Clipboard functions |
- |
+ |
+ |
| DDL for tables and views |
- |
+ |
+ |
