DDL source navigation

Open an object's definition right from the query instead of going on a tree-hunting expedition.

Reading a query and need to see what an object really looks like? Cmd-click on macOS or Ctrl-click on Windows/Linux to open its definition directly. No tree hunting and no emergency sp_help required. Hold the modifier first and resolvable names underline, so you know what will open.

What you can click

Tables, views, stored procedures, functions, and user-defined types. You can also open the same view from the data-model rows in the open dialog.

SQLly

What it shows

A read-only, syntax-highlighted definition, with a header naming the object, where the source came from, the database, and the connection:

• Views, procedures, and functions - the server's own stored definition.
• Tables - a CREATE TABLE with columns (type, nullability, identity, collation, defaults) and the primary key, then appended Indexes, Foreign Keys, and Triggers sections. It's labelled “Generated from catalog metadata” when SQLly builds it from the catalog rather than a stored definition.

Each section is best-effort: if one can't be read it appends a -- … unavailable comment instead of failing the whole view. A toolbar gives you Copy and Open as Query - the generated DDL is never dropped into an editable tab unless you ask.

How to configure it

Under Settings › DDL navigation you can enable or disable it, choose the activation modifier, and pick where it opens - a new tab (the default), a side panel on the current tab, or a popup window.

Supported on SQL Server (the fullest - generated tables with index/FK/trigger sections, plus routines, views, and types), PostgreSQL, MySQL/MariaDB, and SQLite.