SQL Visualizer provides the ability to search for objects or text across multiple databases and servers.

The search navigation section allows you to specify what you want to search for and where you wish to search for it.

The search criteria text can be a simple text match, e.g. 'Orders', or a regular expression such as 'Employees.*Orders'. When using a regular expression make sure you check the Use Regular Expression check box. N.B. Using regular expressions can take significantly longer to complete compared with a simple text search criteria.

To search for the criteria in the object's name only, check the Name check box. To search within the object's content, such as the text of a stored procedure, check the Content box.

Check the object types you wish to include in the search, such as tables, view, stored procedures, etc.

Finally check the databases you wish to search in.

To initiate the search click the Search button.

When the search executes a window will be displayed containing the search results. Because the search may take some time to complete, you can click the Cancel button to stop at any time, in which case partial results will be displayed. The results can be sorted and grouped to make it easier to find the objects you are looking for. The results window contains full details of where the match was found.

This window is similar to the Object View window with several options available on the context menu including scripting. When scripting found objects, one additional feature is available. The search criteria text is highlighted to show where the match was found.

To clear the highlighting select Clear Highlighted Matches from the context menu.