SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Querying SQL/MX Metadata

HP NonStop SQL/MX Installation and Management Guide—523723-004

8-4

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 detailed information and examples of this command, see the SQL/MX Reference

Manual.