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

MXCI Commands
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
4-82
SHOWDDL Command
--- SQL operation complete.
>>
SHOWDDL Command
Considerations for SHOWDDL
Examples of SHOWDDL
The SHOWDDL command displays the DDL syntax used to create a table, view, or
stored procedure as it exists in metadata and optionally lists the object’s dependent
objects. You can use the SHOWDDL output as input to MXCI to recreate the specified
object.
SHOWDDL is an SQL/MX extension.
procedure-name
specifies the name of a stored procedure. If you do not fully qualify
procedure-name, SHOWDDL uses the default catalog and schema for the
session.
object-name
specifies the ANSI name of a table, view, or SQL/MP alias. If you do not fully
qualify object-name, SHOWDDL uses the default catalog and schema for the
session.
SQLMP
specifies that SQL/MP DDL is to be generated. The default is to generate DDL for
an SQL/MP object in SQL/MX syntax.
SHOWDDL {[PROCEDURE] procedure-name }| {object-name
[,SQLMP]|[,DEPENDENT objects]]}
procedure-name is:
[[catalog-name.]schema-name.]procedure-name
object-name is:
[[catalog-name.]schema-name.]object-name.
objects is:
{ TABLES | CONSTRAINTS }
Note. The SQLMP option is applicable only for SQL/MP tables.