How to search for database objects

This topics discusses how to search for objects in a database using Search.

Search

  1. Click Find Objects on the Database menu, or press Ctrl+D, F.
  2. Click Object Search to switch to the Search objects by name and DDL mode.
  3. In the Search text box, enter the search string.
  4. Optionally, click options to select an additional find option from the drop-down list box. The available options are Match Case, Match Whole Word and Use WildCards. By default, the Use WildCards option is selected.
  5. Optionally, click Group results to group results by the object type.
  6. You can change the scope of search results by specifying the search parameters, such as an object type, database, and connection to search in.
    • Object types. Select object types, in which the search will be performed. By default, all object types are selected.
    • Database. Select a database to search in from a drop-down list. The database you are currently connected to is selected by default.
    • Connection. Select a connection for search from a drop-down list. The connection you are currently using is selected by default.

  7. To start the search, Click the Start search button in the Search text box. During the search, you will see the button with a binocular and a progress spinner indicating that the search is in progress. You can stop the search at any point by clicking the binocular button.

    Search in progress

  8. When the search is completed, the details of search results will be displayed in the Search Results grid.
  9. Optionally, you can set a filter for each column in the Search Results grid.

  10. When you select a result in the grid, the Preview window below the grid displays the DDL statements associated with the selected result.

    Main Window

Download dbForge Studio for SQL Server and try it absolutely free for 30 days!

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?
Download a free 30-day trial