SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-67
SHOWDDL Command
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.
Considerations for SHOWDDL
•
SHOWDDL cannot replicate the original object exactly.
For ways in which the output of SHOWDDL can differ from the original DDL used
to create an object, see Differences Between SHOWDDL Output and Original DDL
on page 4-68.You can use SHOWDDL only within an MXCI session.
•
SHOWDDL requires that TMF, NonStop SQL/MX, and MXCI be available and
running on the system.
•
SHOWDDL displays all output in the English (ISO88591) character set only.
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.