Key features
This chapter introduces the main features provided by the Schema Tree Browser.
Generate SQL
Automatically generates INSERT/UPDATE/DELETE/SELECT/MERGE SQL templates for database objects (Table, View, Materialized View).
Supported objects
Use the Generate SQL feature for The following database objects.
Table
View
Materialized View
Execution
Find the desired item (Table/View/Materialized View) in the object tree.
Right-click on the item to open the context menu.
Select 'Generate SQL' from the menu.
Generate SQL window
In the SQL window that appears when executing Generate SQL, the following information are shown.
The names of all columns in the selected object
SQL template for each column's data type
Example automatically generated INSERT/UPDATE/DELETE/SELECT/MERGE statements
Execution
Copy the generated SQL template.
Enter the correct value for the data type.
Search Object
Provides the search function of Schema Object.
The user can search for a Schema Tree Object with the desired conditions by entering values such as Connection, Owner, Type, Object Name, etc.
Last updated