SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

SHOWDDL Command
Use the MXCI SHOWDDL command to display the DDL syntax equivalent to the syntax that was
used to create an SQL/MX table, view, or SPJ and its dependent objects. This command also
supports SQL/MP alias names. You can choose to display the DDL for the underlying SQL/MP
object and its dependent objects either in SQL/MX or in SQL/MP DDL syntax. The command is
especially useful for displaying a thorough description of an object as it exists in metadata.
Note that the SHOWDDL output is derived from current metadata and, therefore, might not match
the DDL originally used to create the object.
SHOWDDL is also useful for displaying the names that NonStop SQL/MX generates for constraints
when there is no user-supplied name.
The INVOKE command is related to the SHOWDDL command, but INVOKE displays only
information about the columns of a table or view. In comparison, you can use the SHOWDDL
command to see a table, view, or SPJ (and its dependent objects) as it exists in the metadata, and
then use the output to create a replica of the object, including its dependent objects.
For more information, see the HP NonStop SQL/MX Release 3.2 Reference Manual.
SQL/MX Metadata Tables
Figure 2 (page 108) shows the SQL/MX metadata table structure.
SQL/MX Metadata Tables 107