- Path Finder: candidate tables now show a confidence estimate.
- Each table in a distance column is labeled with a percentage estimating how likely it truly
belongs on the path. It is based on how specific (few neighbors) a table is compared to the
other candidates at the same distance. A tooltip explains the value. - New option "Sort tables by confidence": tables within a distance column are ordered by
confidence (most likely first) instead of alphabetically. - The "Excluded Tables" list has been simplified: check box and table name now share a single
column, next to the "Neighbors" count. Hints and tooltips explain that checking a table
rebuilds the graph without it, forcing the search to route around it, and that tables with
many neighbors are usually shared reference tables and thus good candidates to exclude first.
- Each table in a distance column is labeled with a percentage estimating how likely it truly
- SQL Console: new option "Allow empty lines in statements". If checked, statements are
terminated by ";" only, so a statement may contain empty lines, and "Run" executes exactly the
one statement at the cursor position. Otherwise an empty line terminates a statement too. - SQL Console: a "GO" batch separator (Microsoft SQL Server / Sybase) is no longer sent to the
database and no longer counted as an executed statement. - SQL Console: after executing DDL, the metadata tree is now updated incrementally instead of
being reloaded completely. Only the affected schema's "Tables"/"Views" node - and the details
of the affected table if it is currently selected - are updated, leaving selection and scroll
position untouched. CREATE/ALTER/DROP/RENAME TABLE, CREATE/DROP VIEW and CREATE/DROP INDEX are
recognized; anything else falls back to the full refresh as before. After a rollback no refresh
is done at all, since nothing has been committed. - "Analyze SQL" now also proposes associations based on DDL statements: foreign key constraints
in "CREATE TABLE" as well as "ALTER TABLE ... ADD [CONSTRAINT ] FOREIGN KEY (...)
REFERENCES ...". - BLOB/CLOB content preview:
- The detected content type, the image thumbnail and the "View" button are now shown directly
in the cells of the result tables (Data Browser and SQL Console "Rows"/"Columns"), not only
in the details view. - SVG images are rendered. They are scaled proportionally, small icons are enlarged to a
legible preview size. - A ZIP archive containing exactly one entry shows the content type of that entry.
- The detected content type, the image thumbnail and the "View" button are now shown directly
- Icons and tooltips have been added to many menu items, toolbar buttons and dialogs of the
Data Model Editor, the Data Browser and the SQL Console. - Fixed: the "All non-empty" item of the Data Browser's related-tables menu showed
"Counting rows... 100%" before the row counting had actually started.