Overview by Statement Type report

The Statement Type report displays the number of each CDL statement (ALTER, DROP, and CREATE) required to match the two schemas. The report also displays a breakdown of the objects that each statement affects.

New Workbench console
Classic Workbench console

#	Description	Details
1	Show Compare Report button	Updates the compare reports
2	Show CDL button	Displays the CDL statements in the Scratchpad Note You cannot run the CDL from the Scratchpad.
3	Reports tab	Displays the reports
4	Report description	Describes what the pie chart is showing For example, the description in the figure indicates that the pie chart shows results for the CREATE action.
5	Pie chart section	Shows the objects breakdown for the selected statement (ALTER, CREATE, DROP) in the column chart When you click on a pie section, a list of all the CDL statements for the selected object type is displayed.
6	Report selector	Enables you to select the following reports: Overview by Statement Type Overview by Object Type
7	Schema Management options button	Displays the Schema Management options See Setting-Schema-Management-options.
8	Help button	Displays the online Help
9	Object color legend	Indicates the color that corresponds to each object type in the pie chart
10	Column chart showing the count of CREATE, ALTER, and DROP statements required to make the first structure identical to the second structure	When you click on a column, displays the object type breakdown

This report is interactive. You can change the information displayed by clicking or hovering over report elements.

You can navigate through the report as follows:

To	Do this
List statements for the selected object type and statement type	Click the relevant section of the pie chart.
Update the object breakdown in the pie chart	Click the relevant statement column in the column chart.
Update a list of statements for the selected object type and statement type	Click the relevant section of the pie chart.
View the count information	Hover over the relevant column of the column chart or relevant segment of the pie chart.

Example

This example lets you view the number of dropped table spaces:

In the Summary by Statement Type column chart, click the column representing the DROP action.
In the Object Type Breakdown pie chart, hover over the segment representing table spaces, then click the segment representing table spaces.
A list of DROP TABLESPACE statements is displayed.

Example

This example lets you View a CREATE INDEX statement for a specific index:

In the Summary by Statement Type column chart, click the column representing the CREATE action.
In the Object Type Breakdown pie chart, click the segment representing Indexes.
A list of CREATE INDEX statements is displayed.
In the CREATE INDEX Statements panel (left pane), select the CREATE INDEX statement for the specific index.
The detailed CDL statement is displayed in the right pane.

#	Description	Details
1	Show Compare Report button	Updates the compare reports
2	Show CDL button	Displays the CDL statements in the Scratchpad Note You cannot run the CDL from the Scratchpad.
3	Reports tab	Displays the reports
4	Report description	Describes what the pie chart is showing For example, the description in the figure indicates that the pie chart shows results for the CREATE action.
5	Pie chart section	Shows the objects breakdown for the selected statement (ALTER, CREATE, DROP) in the column chart
6	Report selector	Enables you to select the following reports: Overview by Statement Type Overview by Object Type Details
7	Schema Management options button	Displays the Schema Management options See Setting-Schema-Management-options.
8	Help button	Displays the online Help
9	Show object color legend button	Shows or hides the object-color legend
10	Object color legend	Indicates the color that corresponds to each object type in the pie chart
11	CDL statement detail pane	Shows the detailed CDL statement required to perform the action for the selected object (in this example, a CREATE statement for the table space)
12	List of CDL statements	Lists the CDL statements (in this example, a list of the CREATE TABLESPACE statements) The detailed CDL for the selected statement is displayed.
13	Column chart showing the count of CREATE, ALTER, and DROP statements required to make the first structure identical to the second structure	When you click on a column, displays the object type breakdown When you double-click on a column, displays a list of all the CDL statements for the selected column

This report is interactive. You can change the information displayed by clicking or hovering over report elements.

You can navigate through the report as follows:

To	Do this
List statements for a statement type	Double-click the relevant statement column in the column chart.
List statements for the selected object type and statement type	Double-click the relevant section of the pie chart.
Update the object breakdown in the pie chart	Click the relevant statement column in the column chart.
Update a list of statements for the selected object type and statement type	Click the relevant section of the pie chart.
View the count information	Hover over the relevant column of the column chart or relevant segment of the pie chart.

Example

This example lets you view the number of dropped table spaces:

In the Summary by Statement Type column chart, double-click the column representing the DROP action.
In the Object Type Breakdown pie chart, hover over the segment representing table spaces, then double-click the segment representing table spaces.
A list of DROP TABLESPACE statements is displayed.

Example

This example lets you View a CREATE INDEX statement for a specific index:

In the Summary by Statement Type column chart, click the column representing the CREATE action.
In the Object Type Breakdown pie chart, double-click the segment representing Indexes.
A list of CREATE INDEX statements is displayed.
In the CREATE INDEX Statements panel (left pane), select the CREATE INDEX statement for the specific index.
The detailed CDL statement is displayed in the right pane.

Overview by Statement Type report

On this page