HP Integrity NonStop J-Series - Manual (Page 64)

Figure 22 SHOW DDL dialog
NOTE: The SHOW DDL option is available only for a schema node and its child nodes in the
navigation tree. The SHOW DDL option is not available for catalogs and the Schemas folder.
In the SHOW DDL... dialog, the Select Objects pane displays the list of systems and the objects that
they contain. You can select these objects.
If you select the SHOW DDL option on a folder node in the main navigation tree, the Select Objects
pane displays the navigation tree with the corresponding folder node and all its child nodes
selected. If you invoke the SHOW DDL option on a leaf node in the main navigation tree, the Select
Objects pane displays the navigation tree with the corresponding leaf node selected.
You can select objects from only one schema. If you select objects from different schemas, an error
message appears.
Table 19 (page 64) describes the options in the SHOW DDL... dialog.
Table 19 SHOW DDL options
Description Option
Loads the SHOW DDL output of the selected objects and replaces the contents in the DDL
Output pane. Load
Appends the selected objects to the existing contents in the DDL Output pane. Append
Clears the check boxes against the selected objects in the Selected Objects pane. Clear All
Clears the DDL Output field. Clear
Saves the contents of the DDL Output field using the File menu dialog. Save
Closes the SHOW DDL... dialog. Close
Viewing schema views and their properties
To view the schema views and their properties:
1.
Log on to the HP NonStop SQL/MX Database Manager.
64 Viewing database objects