0

Are there any tools or extensions that all you to live filter database objects inside SQL Server Management Studio's Object Explorer?

Here's what Currently Exists

The Out-of-the-box functionality allows you to filter objects, but is hidden behind a modal which disrupts the user experience. It also requires you to first navigate to the correct scope before applying filters and if you have a typo, you have to restart the whole flow

SSMS 2017 Object Explorer

Ideal Solution

Similar to Solution Explorer Search live search bar in Visual Studio Solution Explorer Ctrl + ;

Visual Studio 2017 Live Search

Or the Go To finder in Visual Studio Ctrl + ,

Go To All

Current Alternatives

The Object Explorer Details page kind of provides this feature:

Object Explorer Details

However, this has three primary drawbacks

  1. Requires a second window to open
  2. Does not provide Live / Incremental Search
  3. Appears to only match on whole name, so doesn't have substring matching or wildcards
0

Here are some SSMS extensions that add searching functionality

1. RedGate SQL Search

Get results as you type. Matches on object name and also object text. Indexes objects for super fast search.

RedGate SQL Search

2. dbForge SQL Search

Matches on object name and also object text. Substring Matching. Indexed. Must hit return. Switch quickly between schema and data searches

devart dbForge SQL Search

3. Apex SQL Search

Matches on object name and also object text. Substring Matching. Indexed. Must hit return. Switch quickly between schema and data searches

Apex SQL Search

4. SQL Hunting Dog (2008 / 2012 / 2014 [1])

Super snappy, smallest visual footprint means it can easily stay docked above or below object explorer and leave file navigation to the internal tools. No support yet for SSMS 2017+

SQL Hunting Dog

Honorable Mentions ($$)

  1. SSMS Tools Pack ($30) only data search, not object search
  2. SQL Smash ($99)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.