SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-67
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, including the object’s dependent objects. The
output returned by SHOWDDL can be used as input to MXCI to re-create the specified
object, including its dependent objects.
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 in SQL/MP syntax. The default is to
generate DDL for an SQL/MP object in SQL/MX syntax.
SHOWDDL {[PROCEDURE] procedure-name }| {object-name [,SQLMP]}
procedure-name is
[[catalog-name.]schema-name.]procedure-name
object-name is
[[catalog-name.]schema-name.]object-name.