Using Object Search

SQL Query Analyzer Help

SQL Query Analyzer Help

Using Object Search

Use the object search feature to find objects in the current database server. Object search is accessible through a button on the toolbar, and through the Object Search command on the Tools menu.

Important  The object search feature is not available when connected to an instance of SQL Server 6.5.

To find an object

  1. Click the Object Search button to display the Object Search dialog box.

  2. In the Object name box, type the name of the object to be found, or use ALL to find all objects of the specified object types.

  3. For a case-sensitive search, select the Case-sensitive check box. Case-sensitive searches are valid only if the database server is case-sensitive.

  4. In the Database list, click the name of a particular database or click ALL.

  5. In the Hit Limit dialog box, enter the maximum number of search hits.

  6. In the Object type check boxes, select one or more types of objects to be located.

  7. To locate extended properties associated with the selected object types, select Extended Property.
    • You can search for all property names or a specific name.

    • You can search for all property values or a specific value.
  8. Click Find Now to execute the search.

The results are displayed in the lower portion of the dialog box.

Note  You can drag one or more objects in the results to the Query window. You can also right-click in the results to display the Context menu, which enables you to open the selected object in the Open Table window, or perform various editing and scripting activities.