Export (0) Print
Expand All

Object Search Dialog Box

SQL Server 2000

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.

Show:
© 2014 Microsoft