SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

MXCI Commands
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-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, 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 will display the following new attributes for the IDENTITY column:
•
Default specification of the IDENTITY column
•
Internal sequence generator attributes
•
Location of the SG Table
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]}
procedure-name is
[[catalog-name.]schema-name.]procedure-name
object-name is
[[catalog-name.]schema-name.]object-name.
Note. The SQLMP option is applicable only for SQL/MP tables.