Search for SQL Objects and Table Data in SSMS with ease

Text Search

You can find an object by name in a SQL Server database, and Search will identify all objects containing the search query including the stored routines.

Search for:

• text
• numbers
• dates
• unique identifiers

The tool will search across both objects' names and bodies.

Data Search

Search for SQL Server includes the Data Search Mode allowing to locate the table, view, stored procedure, function, trigger, etc. containing the required data and then view this data.

For convenience, the results will be displayed in a grid, where you can check:

• name of an object
• schema
• database
• object type
• matches count

Wildcard Search

You can use wildcards to substitute any character in a search string. With wildcards, you can match zero or more characters, a set of characters included or absent in an object name being searched, etc.

Using wildcard search feature you can maximize your search results.

SQL Fragment Search

Using Search for SQL Server, you can find a specified SQL code fragment in tables, views, stored procedures, functions, triggers, etc. For example, searching for a "alter" command will return examples of all code fragments containing the command.

Quick Navigation

This feature allows to quickly locate an object rather than browsing through a list of objects in the Object Explorer. With this database search tool, you can jump to the found object in Object Explorer in a single click.

Regularly, finding anything in the Object Explorer requires a lot of time and eye strain. Using Search for SQL Server, you can eliminate those and navigate to the found object in a flash.

Customizable Search

Search for SQL Server has two modes: DDL and Data modes. Having chosen the mode, you can then customize your search by setting up search criteria:

• Match case
• Match whole word
• Use wild cards

Multiple Search

You can quickly search numerous object types across multiple databases at the same time. This option also allows simultaneously search across multiple database object types:

• tables
• views
• functions
• triggers, etc.

Search for SQL Server helps save time and extend productivity.

Search Results Management

Search for SQL Server allows you to sort search results according to your needs. With the tool you can:

• sort
• filter
• group

the results in a grid for a convenient use.