Extract

Go Up to Available object actions by DBMS

You can extract the statements required to create existing objects into an Interactive SQL window.

Note: For information on setting preferences for this action, see DDL Extract Options.

Platform Availability

• DB2 LUW
• DB2 z/OS
• MySQL
• ORCL
• SQL SVR
• SYB ASE
• SYB IQ

To Extract the DDL for an Object

1. Initiate an Extract action against one or more objects. For more information see Initiating an object operation.

The DDL Editor opens with the DDL to create the selected objects. For more information, see Using the DDL Editor.