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
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. See Filter Databases and Objects for more information.
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. See Filter Databases and Objects for more information.
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.
Toad allows you to filter the list of databases or objects that display in the Object Explorer. You can use filters to reduce the number of databases and/or objects to work with.
You can create a Quick filter by entering a search string in the object filter field. You can also use the Filter dialog (click ) to choose additional filter options. If you use the Filter dialog, you can also name and save your filter.
Can be used to quickly filter objects for a single connection or schema.
Create a Quick filter by entering a search string in the object filter field.
Applies to the current schema (or to objects in the current schema) only.
Once applied, a Quick filter is in effect on that connection when you reconnect or relaunch Toad.
Because Quick filters are not named, they cannot be applied to other connections by selecting from the filter list. You must recreate the Quick filter for each connection/schema.
Use like a Quick filter, but add more detail by using the Filter dialog to enter filter criteria.
Use this method to create an unnamed database filter.
-- same behavior as a Quick filter --
|Named||Create and save named filters to reuse and to apply to other connections
Once applied, a Named filter is in effect when you reconnect or relaunch Toad.
Can be re-used on other connections of the same data source type (DBMS).
Note: If you rename a table that has a filter defined, it results in an orphaned filter. Orphaned filters are automatically removed unless you used a tool other than Toad to remove them.
A filter is associated with a specific list of objects from a specific database. Consider the following guidelines when setting filters:
A filter applied to a set of objects such as tables in one specific database connection is not automatically applied to the list of objects in another database connection.
A filter applied to a list of tables on one schema in the database is not automatically applied to the list of tables for a different schema in the same database.
A filter set for a specific schema or object is applied when altering objects, using the SQL Editor, Master Detail Browser, etc., for that schema or object.
Tip: To apply any currently-set filters to the code completion list in the editor, select the Apply explorer filters option in Tools | Options | Editor | Code Completion.
To create a Quick filter (objects only)
Enter a search string to use for filtering in the object filter field (below the database field) in the Object Explorer.
Note: As you enter a search string, the currently specified Search Condition displays in a blue banner below the object filter field. This Search Condition will be used in your filter. To change the Search Condition, click and select a different one from the Search Condition drop-down.
To create a Detailed filter
Specify criteria for the filter in the Properties tab. Review the following for additional information:
|Search String||Enter a text string and search characters to use for filtering.|
Select a search type to use in this filter.
Note: You can set a default value for this field in Tools | Options | Explorer | General. If you don't specify a default value in Options, this field defaults to the search type you specified the last time you created or modified a filter (includes previous sessions).
Tip: To include in your text string certain characters normally used in search logic, such as the underscore (_), use one of the following Search Conditions:
In DB2 connections, this property is set to True by default.
To create a Named filter
Creating a new Quick filter from a current filter
If you apply a filter and then completely clear the object filter field before entering a new search string, all properties return to the default values.
Note: The Search Condition also returns to the default value. This default is either the Search Condition you specified the last time you created or modified a filter or it is the new default you specified in Options.
To use Named filters
To clear a Named filter, click the down-arrow beside and select <None>.
To determine if a filter is applied, observe the filter icon.
No filter is applied (all databases/objects display).
A filter is applied.
You can export all named filters and you can export all filters defined for the current connection.
To export Named filters or all filters defined for the current connection, click the down-arrow beside in the database field and select Export Filters.
Tip: Click in the Database Explorer (Viewer) toolbar to clear all database, object, and data filters.
Click here to view a video of this feature.
You need to build a query listing customers and want to know more about the table before writing the query.
Note: This exercise uses the Toad Sample Database. This connection does not have the relationship and script tabs. The tabs available can differ depending on the type of connection.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To understand a table using the Database Explorer
Connect to the Toad Sample (Access) database in the Navigation Manager.
Place the cursor over the LAST_NAME column, click , and select Acton.
The only row that now displays is the one with Acton as the last name.
Click in the top left of the Data tab.
Create the following filter in the Where Clause tab:
CONTACT_ID > 2000
The filter string displays at the bottom on the grid. Click to remove the filter.
Select a row of data in the grid. Notice that the row number changes in the bottom right of the status bar:
Select the SEX column header and drag it the area above the columns that says "Drag a column header here to group by that column":
You can expand each group to view the row data.
Go to the BIRTH_DATE column and use the date picker to change the date.
Each data type have an appropriate editor.
Note: If you are using Oracle or a database that does not have auto commit on, you will need to press Commit at the left hand bottom of the window.
Press F5 in the data grid. Notice the bottom right status bar now says "1 of 50 (scroll for more)".
The option you set controls the number of rows fetched in the Data tab.
You can quickly locate an object rather than browsing through a list of objects in the Database Explorer orObject Explorer. Object Search locates the following:
Names of objects for a string.
Text in objects that include source code, which typically includes procedures, functions, triggers, data types, and views. However, the database provider determines which objects include source code.
Variable names and comments in the object's source code.
Column names for tables and views.
To search for objects
Specify search criteria and click Search.
Note: To append additional search results to the current search, click Append instead. If you click Search, new results replace the previous search results in the data grid.
To remove objects from the search results, right-click the objects in the data grid and select Remove Items. This is useful if you want to narrow the list of results to relevant objects.This does not remove the objects from your database.
To create a DDL script from the search results, right-click the data grid and select Create DDL Script. You can then paste the results into the Editor.
To perform any actions available for the object, such as creating, altering, dropping, exporting, and generating reports or SQL, right-click the results in the data grid and select an option.