Object Explorer
You can view database objects for the current connection with the Object Explorer. This feature is useful for dragging and dropping database objects into an open Editor, Query Builder, or other document window. Right-click the objects in the Object Explorer to access additional features such as multiple tasks and actions.
To open the Object Explorer
- Select View | Object Explorer.
-
Review the following for additional information:
Schema (first field)
Select the schema you want to view. You can filter the list of schemas that display. Filter Databases and Objects
Object Filter (second field)
You can quickly set a filter in this field. To do so, enter a name or partial name of an object and press ENTER. Any advanced object filters you set display in this field.
You can also perform advanced filtering based on case sensitivity, statistics, or other options. Filter Databases and Objects
Tip: You can enable an option to filter using regular expressions in Tools | Options | Explorer | General.
Note: For tables and views, the columns, data types, and comments display at the bottom of this window.
Tips:
- To navigate to a previously selected object, click
. You can also click
to move to the next selected object.
- To locate objects including procedures, functions, views, variable names and comments in an object's source code, use Object Search. Search for Objects
- To use a different method to select objects such as tabs, drop-downs, or a tree view, click
.
- To generate reports, export data, create SQL statements, or send objects to the Project Manager, SQL Modeler, or Master Detail windows, right-click the objects and select an option.
- To open the Background Processes window and cancel a query, click the progress bar at the bottom of the window.