HP Neoview Release 2.4 Software - Manual (Page 53)

Displaying Schema DDL and Their Properties
To display schema DDL information, a DDL tab appears in the right pane when these objects
are selected in the navigation tree:
• Schema
• Table
• Table Index
• View
• Materialized View
• Materialized View Index
• Materialized View Group
• Procedure
• Synonym
• Trigger
DDL Tab
The DDL tab displays DDL output from the Show DDL command in the right pane. You can
highlight and copy contents, but you cannot edit the contents.
The external format of the Show DDL output is displayed. For more information on the format
of the Show DDL command, see to the SQL Reference Manual.
Show DDL
Show DDL allows you to select objects for which you want DDL output fetched and displayed.
NOTE: Opening up Show DDL to the system-level allowing you to select different catalogs
and schemas and their objects may cause performance issues. To avoid performance issues, Show
DDL limits the selection to a specific schema.
• Select a node in the navigation tree, right-click the Show DDL menu and the Show DDL
dialog box appears.
The Show DDL menu is available only for a schema node and its child nodes in the
navigation tree. The Show DDL menu is not available for catalogs folder or the catalog and
schemas folder.
Displaying Schema DDL and Their Properties 53