You can search for database objects in the Data Source Explorer that have names that match a text string you specify.
- From the Data Source Explorer, right-click the database or user in which you want to search for an object.
- Click The .Find Object dialog opens.
- For Search Value Enter the exact name of the object you wish to find. The search is case-insensitive. If you know or wish to enter only a portion of the object name, click Advanced Find to open the Advanced Find dialog where you can specify only a portion of the object name in your search criteria.
- Use the Object Type list to specify the type of database object you are searching for. If you wish to search more than one object type, click Advanced Find to open the Advanced Find dialog where you can specify several types of objects to search.
-
Click Find.
- If you used the basic Find Object dialog box to search, the Data Source Explorer tree expands to show you the first instance of an object it finds matching your criteria.
You can press F3 or right-click the Data Source Explorer tree and click to search for other objects that have the same name.
- If you used the Advanced Find Objects dialog box to search, all results of the search are displayed in a tab of the Object Viewer.
- If you used the basic Find Object dialog box to search, the Data Source Explorer tree expands to show you the first instance of an object it finds matching your criteria.