Using Object Explorer Details and SQL Server Object Search
Object Explorer Details, a component of SQL Server Management Studio, provides a tabular view of all the objects in the server and presents a user interface to manage them. The capabilities of Object Explorer vary slightly depending on the type of server, but generally include the development features for databases and management features for all server types.
The Object Explorer Details pane is visible in the Management Studio by default. If you cannot see Object Explorer, on the View menu, click Object Explorer Details or press F7.
Management Studio presents dates formatted with the Microsoft Windows Regional and Language Options in effect when Management Studio was started. Restart Management Studio to reflect newer settings.
Object Explorer Details can be used to navigate through folders and objects on your SQL Server instance. On 32-bit operating systems, Object Explorer can only display 64,000 objects. An icon must be selected to access additional objects.
Object Explorer Details includes a toolbar which contains the icons described in the following table. Icons are only available when appropriate.
Moves to the previous items displayed in Object Explorer Details. Re-runs a search when the previous display is the result of a search operation.
Moves to the next screen after a Back operation is selected.
Moves to the parent object or folder.
Sets the focus of Object Explorer to the selected object in Object Explorer Details.
When available, shows a configurable subset of objects.
Refreshes the display in Object Explorer Details.
Provides an area to enter a search term for certain database objects.
Column Header Selections
Object Explorer Details has selectable columns. You can right-click in any column header and check the items that you want to display. Your selections will be persisted across the different objects you navigate through. Selections for each user are retained when you leave and restart SQL Server Management Studio.
Showing all columns for some object types (such as Databases) might slow the display rendering slightly for large sets of objects.
Clicking one time on a column header will sort by that column. Clicking again on the same header reverse-sorts by that column. Sort selections are maintained for each user across objects and folders, and on Management Studio restart.
Certain lists of objects displayed in Object Explorer Detail can be filtered using the Filter icon on the Object Explorer Details toolbar. The icon will be enabled when filtering is possible.
The very bottom area of Object Explorer Details contains a panel that displays certain details of the selected object. Multiple object selections show only the count of the objects. When items are selected in the panel, click the Copy icon to copy the displayed text to the clipboard.
Multiple Object Selection
Object Explorer Details supports multiple object selection. For example, if you select Tables in Object Explorer, then in the Object Explorer Details window if you hold down the Ctrl key, you can select several tables, right-click them, and then select Delete or Script Table AS to act on all the selected tables immediately. The standard copy commands will copy the displayed text to the clipboard.
Standard wildcard characters are supported. For example, searching for dm_os%counters returns both dm_os_memory_cache_counters and dm_os_performance_counters. For more information, see How to: Search with Wildcards.
Each search is scoped to the current focus in the Object Explorer tree. For example, if the Object Explorer focus is on a database, search for dm_os%counters returns dm_os_memory_cache_counters and dm_os_performance_counters in that database. If the Object Explorer focus is on the Databases node, all databases are searched and multiple instances of the dynamic views are returned.
Searching large object sets can take a long time and slow server performance.