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
  • Search accross multiple instances without being connected to them (SQL Search Everywhere only)
Download SQL Search

Features

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.

Search from anywhere and offline*

Using SQL Search Everywhere, you can search across multiple instances whithout being connected to them. * SQL Search Everywhere only

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.