Object Search Dialog Box
Use the Object Search dialog box to locate objects in the current database server.
Options
Object name
Specify the name of the object to find.
Case sensitive
Specify a case-sensitive search, regardless of the case-sensitive setting of the database server.
Database
Specify the database to be searched or specify all databases.
Hit limit
Specify the maximum number of items to return.
All object types
Consider all object types when performing the search.
System table
Search for system tables.
User table
Search for user tables.
View
Search for views.
Stored procedure
Search for stored procedures.
User defined function
Search for user defined functions.
Column
Search for columns.
Index
Search for indexes.
Trigger
Search for triggers.
Extended procedure
Search for extended stored procedures.
DRI constraint
Search for declarative referential integrity constraints.
Extended property search
Search for extended properties.
| Property name | Specify the name of the property to find. |
| Property value | Specify the property value to find. |
Find Now
Begin the search operation. The search results are displayed in the lower part of the window.
Note Right-click 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.
New Search
Clear the selected items so new search criteria can be specified.