Schema tree

✓ functional

Learn how databases, schemas, and objects settle into a tree that stays easy to navigate.

Expand a connected database to explore its objects as a tree. Its shape is yours to choose in Settings › Data Model › Server Explorer.

Schema display

Mode	Shape
Group by schema	Each schema gets its own folder; objects show just their name - `server ▸ database ▸ schema ▸ Tables ▸ Orders`.
All schemas together (default)	Schemas are mixed under shared folders; each object shows its schema as a prefix - `Tables ▸ dbo.Orders`.

Object-type folders

Objects settle into Tables, Views, and Programmability, which contains Types, Procedures, and Functions. Engines may also show Materialized Views, Sequences, Synonyms, Extensions, Events, and database-level Triggers. Expand a table for its Indexes, Statistics, Foreign Keys, Triggers, and Constraints.

Empty schemas & aligned metadata

General schemas - show them all, hide the empty ones, or show non-empty ones inline and collect the empties into an “Empty Schemas” folder.
Line up object metadata - align each item's name, data type, and nullability into columns (toggle per surface: tables, views, procedure and function parameters), with per-column left/right alignment and an optional fixed width.

SQLly server explorer schema tree with aligned metadata — A database expanded into schema and object-type folders, with column-aligned metadata.

Pinning

Right-click any object - a table, view, procedure, function, database, and more - and choose Pin to keep it close. A pinned object floats to the top of the section it organically lives in: a pinned table leads its own Tables folder, a pinned procedure leads Programmability, a pinned database leads the server's database list. It stays under its natural folder - it isn't lifted into a separate group at the top of the server - so the tree keeps its shape while your most-used objects sit first. Unpin from the same menu.