Query Pilot Object References

The reference badge beside an object name reports how many distinct database objects reference that object on the object browser's selected server.

Object reference badge and source-line popup

Query Pilot reads SQL Server dependency metadata from each database with bounded parallelism. Badges appear as each database completes, and completed dependency sets are cached for the current application session. Use the object browser refresh command to rebuild both object metadata and reference data.

Click a badge to list the referencing database, schema, object, object type, and first matching source line. Line discovery is lazy: the popup opens immediately, then loads the required module definitions in database-level batches and caches them for later navigation. Click a dependent object to open its SQL definition and highlight the complete qualified or unqualified object name at that reference.

Use Copy in the reference popup to place a shareable text report on the clipboard. The report includes the target object and every dependent object's fully qualified name, type, and source line.

Click an inline N refs label in the SQL editor to open the current-script reference list. It uses the same full-width row layout as database references: every row shows the line number and source text, and clicking a row navigates to and selects that object reference.

Workflow

  1. Open Query Pilot, select Objects, and choose the metadata server.
  2. Expand a database, schema, and object-type folder.
  3. Click the N refs badge beside an object. The popup appears immediately while source lines resolve in the background.
  4. Click a dependent object to open its definition. Query Pilot scrolls to the first reference and selects the complete object name.
  5. Click Copy to share the complete dependency report without opening every object.

If a source definition cannot be read, the dependent remains in the list with line unavailable. The reference edge is still valid; only source-line navigation is unavailable.

Reference counts include cataloged dependencies from views, stored procedures, functions, triggers, and synonyms. Cross-database references are included when SQL Server records a resolvable database, schema, and object name. Dynamic SQL assembled inside strings is not included. Objects hidden by SQL Server metadata permissions are also unavailable to the browser.

Related: Query Pilot Objects and Query Pilot.

Documentation revision: 156205574C1604EC