The Code Finder searches database objects and files for a specific text string. Each occurrence of the specified text is listed and the database objects or files where it is found.
Open Database Object or File in SQL Worksheet
The Code Finder window is divided into three sections: search criteria, where to search, and the search result.
The search criteria displays on the top left pane. Review the following for additional information:
Item |
Description |
Text |
Specify text. |
First occurrence only |
Specify whether to search for only the first occurrence of the text in the database object or file. If this option is not selected, all occurrences of the text displays. |
Case sensitive |
Specify whether to search for the text in exact case that you enter it. |
Whole word only |
Specify whether to search for words only |
Regular Expression |
Specify whether to recognize regular expressions in the search string. |
Select where you want to search. Review the following for additional information:
Item | Description |
Look in |
Displays the list of selected objects and files to search. |
Quick Find |
Allows the selection of the database objects belonging to the current database and user (Tables, Views, Procedures, Triggers, Rules, Defaults) and/or the selection of all files belonging to the selected directory. |
Database Objects |
Allows the browsing and selection of database objects from different databases and users. |
Directories/Files |
Allows the browsing and selection of directories or files. . |
The lower pane displays the list of items that matches the search criteria. Review the following for additional information:
Item | Description |
Name |
Database object or file name. |
Line |
Line number of matched specified text. |
Text |
Line of text showing the matched specified text. |
Open Database Object or File in SQL Worksheet
To display the Code Finder window
Click .
Enter a search text or use the down arrow next to the input field to select from a list of previously entered search text. The First occurrence only, Case sensitive, Whole word only andRegular expression checkboxes lets you refine the search.
Select the Quick Find tab to select objects belonging to the current database and user. Or, select the Database Objects tab. Expand the object and select user, object type or object name and click Add. The selected object displays in the Look in pane on the top left indicating that the selected objects will be searched. No duplicate objects can be selected.
Select the Directories/Files tab. Select the directory and enter a file mask or click the down arrow to select from a list of previously entered file marks. If blank, *.* is used indicating that all files will be searched. To search in the sub-directory, select Include sub-directories checkbox. Click Add to select the directory and files. No duplicate files can be selected.
To start searching
Click Search.
To stop the search
Click Abort.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center