Redgate logo for print use

SQL Search

Find SQL fast in SQL Server Management Studio and Visual Studio

  • Find fragments of SQL in tables, views, stored procedures, functions, jobs, and more
  • Quickly navigate to objects wherever they happen to be on a server
  • Search across multiple object types and multiple databases
  • Find all references to an object
  • Search with booleans and wildcards

Download SQL Search now

Why use SQL Search?

Searching stored procedures for a column name in SQL Search in SSMS

Impact analysis

You want to rename one of your table columns but aren't sure what stored procedures reference it.

Using SQL Search, you can search for the column name and find all the stored procedures where it is used.

Using find-as-you-type with SQL Search in SSMS

Work faster

Finding anything in the Object Explorer requires a lot of clicking.

Using SQL Search, you can press the shortcut combo, start typing the name, and jump right there.

Searching for stored procedures containing TODO with SQL Search in SSMS

Make your life easier

You need to find stored procedures you\'ve not yet finished writing.

Using SQL Search, you can search for stored procedures containing the text TODO.

Searching for stored procedures containing SELECT * with SQL Search in SSMS

Increase efficiency, reduce errors

Using SQL Search, you can look for SELECT * in the text of stored procedures and views and replace them with a correct list of columns to improve performance and prevent future bugs.

How to find objects with SQL Search

SQL Search running in SQL Server Management Studio

SQL Search integrates into SQL Server Management Studio and Visual Studio 2017

Selecting which objects to search in SQL Search

Pick the objects and databases you want to search

Using find-as-you-type in SQL Search

Get results as you type

The context menu in the SQL Search search results, showing the option to Select in Object Explorer

Quickly jump to the found objects

“SQL Search has saved me many hours of time, and a lot of frustration.”Chris Yates
Database Administration Manager, Republic Bank

See why Chris Yates relies on SQL Search to search through objects in his 1500 databases.

Read the case study

Searching SQL Server Databases - a case study on Republic Bank's use of SQL Search

SQL Search

Get started with SQL Search

SQL Search is a free add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases.

Free download

Need a hand?

If you'd like any help, or have a question about our tools or purchasing options, just get in touch.

SQL Toolbelt Essentials

SQL Search is part of SQL Toolbelt Essentials

Write SQL twice as fast & make changes in minutes, with the industry-standard tools for SQL Server development.

See what's included