SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

MXCI Commands
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
4-88
Considerations for SHOWDDL

Headings for SQL/MP views are not supported.

Added check not null constraints do not have accompanying "-- NOT NULL "
comments by columns that they determine are not null, as in the output for an
SQL/MX table. This situation is caused by differences in how NonStop SQL/MP
and NonStop SQL/MX implement NOT NULL constraints.

SHOWDDL does not display any table or column privilege information for the table.

If you do not specify the SQL/MP option, SHOWDDL displays the string constants
enclosed with single quotes.