Online Documentation for SQL Manager for DB2

Get an object DDL


In order to get an object DDL you can:

  1. Right-click the object in the DB explorer tree and select the Script to New SQL Editor | Create context menu item.
  2. Right-click the object and select the Edit Table <table_name>... context menu item or double-click the table and then proceed to the DDL tab in the opened table editor window.
  3. Right-click the object in the DB explorer tree and select the Data Manipulation | Export Data as SQL Script context menu item.