Find SQL fast in Azure Data Studio

Find fragments of SQL in tables, views, stored procedures, functions, jobs and more

  • Search across multiple object types and multiple databases
  • View object definitions
  • Quickly navigate to objects wherever they happen to be on a server
Download SQL Search


Discover who has database access

Easily find tables, views, stored procedures, functions or parts of SQL within them. Using SQL Search, you can search for the column name and find all the stored procedures where it is used.

Quickly find databases objects in object explorer

Finding anything in the Object Explorer requires a lot of clicking. Using SQL Search, you can jump to the object right from your search results.

View object definitions

Select a table, a view or a stored procedure and view its definition in Transact-SQL source text.

Installing SQL Search for Azure Data Studio

Step 1

Install the SQL Search extension

  1. A - From Azure Data Studio Ctrl/Cmd+Shift+p, type Extensions: Install from VSIX... and hit enter.
  2. B - Navigate to your downloads folder and select the '.vsix' file you just downloaded
  3. C - Click 'install'

Trouble downloading? Retry the download.

Step 2

Install .Net Core 3.1 Runtime

Install .NET Core Runtime on your machine.

Step 3

Start using SQL Search for Azure Data Studio

  1. A - Launch SQL Search using Ctrl/Cmd+Shift+p, then SQL Search.
  2. B - Select the command you want to use

SQL Search commands

Two commands available to you are:

  • SQL Search: Search In Active Connection - use this command to search across all objects using the current active conection.
  • SQL Search: Reindex Active Connection - SQL Search stores results in a cache, use this command to refresh the data.

You can find more information in the extension page within Azure Data Studio.