Sign in with your SQL login

Parameters

No parameters.

Definition

Columns

Primary key

Nullable columns can't be part of the primary key - uncheck Nullable on the column first.

Check constraints

Runs as your own SQL login against the selected database — anything you could do in SSMS, you can do here.

Query

Finds a value across every table in this database — each table is checked for an exact match on number/GUID columns and a partial match on text columns.

Tables and their foreign key relationships in this database. Click a table to open it. Related tables are grouped together; scroll/drag to pan, Ctrl+scroll or the buttons below to zoom, and use Find to jump straight to a table.

What's happening on this database right now - who's connected, resource trends, who's blocking whom, and any recent deadlocks.

What's happening across every database on this instance right now - who's connected, resource trends, who's blocking whom, and any recent deadlocks.

Top queries by resource consumption, from SQL Server's own Query Store history.

Indexes SQL Server's optimizer estimates would have helped recent queries. Advisory only - review before creating anything.

Statistics with rows modified since their last update, worst first. A high modified % means the optimizer may be working from stale row estimates - consider updating.

Recent deadlocks that touched this database, captured by the always-on system_health session (which is instance-wide - deadlocks are filtered down to this database here). This is a small ring buffer, not a full history - older deadlocks roll off as new ones (or other system_health events) happen.

Recent deadlocks across every database on this instance, captured by the always-on system_health session. This is a small ring buffer, not a full history - older deadlocks roll off as new ones (or other system_health events) happen.

What SQL Server has spent the most time waiting on, server-wide, since the service last started - the classic first stop for "why is this slow". Common background/housekeeping wait types are filtered out. A high Signal Wait % points to CPU pressure rather than resource contention.

Nonclustered indexes with zero recorded reads, and indexes that are redundant with a wider index on the same leading columns - both cost writes and storage for little or no benefit. Usage stats reset when the service restarts or an index is rebuilt, so a recently-restarted server will show everything as unused - check "Since" before dropping anything.

Actual storage per table - data, indexes, and space SQL Server has reserved but isn't using. Row count alone can't tell you this - two tables with the same row count can have very different footprints.

Recovery, compatibility, and other database-level settings - read-only for now.

SQL Server Agent jobs on this server. Unless you're a sysadmin, only jobs that run against this database or that you own are shown.

Manage full-text catalogs on this database - create one here, then add a full-text index to a table from its Structure tab.

Database users/roles and the explicit GRANT/DENY permissions in this database.

Users & roles

Explicit permissions

Which database(s)?

What can this link do?

The SQL Query Editor is disabled because table/view access is restricted below - raw SQL could otherwise bypass that restriction.

Table/view restrictions aren't available when a share grants more than one database - every table and view is visible in each one.

Search and Schema Diagram show the whole database, not just the tables above. Backup Manager Access is bigger still - it hands over the real login's full, unrestricted SqlBackupManager session, covering every database it owns, not just this one.