Open Database Object or File in SQL Worksheet
Code Finder > Open Database Object or File in SQL Worksheet
You can open the matched database objects and files in the SQL Worksheet after performing the Search function in the Code Finder window.
To open the database object or file in the SQL Worksheet
Right-click the object or file and select Open in SQL Worksheet.
The database object’s DDL or the file opens on the SQL Worksheet window and the cursor displays at the beginning of the matching text.
Related Topics
Code Finder Overview
Code Finder Window
Search Database Objects and Files
Regular Expression
Extract Object DDL to File
Save Search Results
Code Finder Functions
Extract Object DDL to File
Code Finder > Extract Object DDL to File
In the Code Finder window, you can extract the DDL to a file for the database objects that contain the search string.
To extract the DDL from an object
-
Perform a search.
-
Select the object from the lower pane.
-
Click Extract to file.
-
Enter a name for the DDL file.
Related Topics
Code Finder Overview
Code Finder Window
Search Database Objects and Files
Regular Expression
Open Database Object or File in SQL Worksheet
Extract Object DDL to File
Save Search Results
Code Finder Functions
Save Search Results
Code Finder > Save Search Results
You can save the search results from the Code Finder in a file.
To save the search results
- Right-click and select Save.
- Select to formate the file as Text, HTML, or Excel Convertible (Spreadsheet).
Related Topics
Code Finder Overview
Code Finder Window
Search Database Objects and Files
Regular Expression
Open Database Object or File in SQL Worksheet
Extract Object DDL to File
Code Finder Functions
Code Finder Functions
Code Finder > Code Finder Functions
Below is a list of available functions within the Code Finder window.
Menu |
Function |
|
Search |
|
Abort |
|
Extract to File |
|
New Search |
Right-click Menu |
Open in SQL Worksheet |
Right-click Menu |
Save |
Related Topics
Search Database Objects and Files
Extract Object DDL to File
Open Database Object or File in SQL Worksheet
Save Search Results
Code Finder Overview
Code Finder Window
Regular Expression