The DDL Wizard DDL Source Dialog Box

The DDL Source Dialog Box displays the source code for one or more schema DDL objects. The option buttons on the left side of the dialog box enable ad-hoc adjustments to the DDL or generate inverse DDL statements (drops, truncates or revokes etc.). The actions the option buttons perform are specific to the type of object on display. The buttons are modified for each DDL type and will always be relevant to the current object.

Clicking on the View button in the object type window of the Schemas & Objects tab causes the DDL Source dialog box to display all currently selected DDL items for the object type. Clicking on the View button in the object name window of the Schemas & Objects tab displays only the DDL code for that specific object.

What the buttons do

Apply Rules

This is the default option and causes all appropriate object rules (see the Object Rules tab help page for more information) to be applied to the DDL code on display. If required, the DDL source code on view will be regenerated to reflect the current state of the rules. When the Apply Rules option is active the View Rules for this Object and Update/Add Rules buttons (see below) will also become active.

Disregard Rules

Activating this option regenerates the DDL code on the display as if no object rules were in force.

Quick Strip

This button removes all storage clause, tablespace and other variable information from the DDL code. The Quick Strip button is designed to make it easy to cut and paste DDL code without also picking up all of the storage specification baggage.

Show Dependent Objects

Dependent DDL objects are objects that are implicitly related to another object. For example, tables can have dependent indexes and primary keys. If an object type is capable of having dependent objects the Show Dependent Objects button will be present. Pressing this button will cause the DDL code for all of the dependent objects to appear below the DDL code for the display object.

Show Create DDL

If this option is enabled the creation DDL code for the object type is shown on the screen.

Generate Drop DDL

If this option is enabled drop statements suitable for the object type on display are generated.

Generate Truncate DDL

If this option is enabled truncate statements suitable for the object type on display are generated. Note: if you generate truncate statements for a table then disable and re-enable statements for the foreign keys of which this table is a parent will also be generated.

Save to Disk

This button provides a quick way to save the contents of the DDL code display to a disk file.

Copy to Clipboard

Pressing the Copy to Clipboard button copies any selected text to the clipboard. If no text is selected, the entire DDL code display is placed on the clipboard. The copy can also be performed by pressing the CTRL-INSERT key.

Find and Find Next

These buttons search through the DDL code on display looking for a phrase that you specify.

View Rules for this Object

An object can have any number of object rules applied to it. This button will start a dialog box that lists all of the rules active for the object. More information can be found on the help page for the Rule Information dialog box. This button is only active when the Apply Rules option is selected.

Update/Add Rules

The Update/Add Rules button launches the Object Rule Update dialog box. This dialog box enables you to add rules that will modify the DDL code for a schema object. This button is only active when the Apply Rules option is selected.