Generating Table DDL Commands

Display the data description language SQL code for adding a table, global temporary table or proxy table to a dbspace. The DDL can be a useful reference and training tool.

Prerequisites
Database Version Table Privileges
SAP Sybase IQ 15.3 and 15.4

None
SAP Sybase IQ 16.0

None
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Schema Objects > Tables, and then select Tables, Global Temporary Tables, or Proxy Tables.
  3. Select one or more tables from the right pane and either:
    • Click the arrow to the right of the name and select Generate DDL, or
    • From the Administration Console menu bar, select Resource > Generate DDL.
    Use Shift-click or Control-click to select multiple tables.
    The DDL view shows the SQL code used to add the selected table to the dbspace.
Parent topic: Tables
Related concepts
Table Columns
Table Permissions
Table Constraints
Table Indexes
Table Triggers
Table Partitions
Related tasks
Creating a Table with No Partitions in the IQ Main Store
Creating a Table with No Partitions in the IQ (Catalog) System Store
Creating a Table with a Hash Partition
Creating a Table with a Range Partition
Creating a Table with a Hash-Range Partition
Creating a Global Temporary Table
Creating a Proxy Table
Viewing Table Data in the Execute SQL Window
Deleting a Table
Moving a Table to Another Dbspace
Validating a System Store Table
Setting the Primary Key
Setting a Clustered Index
Merging Table Data from RLV Store with IQ Main Store
Calculating the Number of Rows in a Table
Moving Table Objects to Another Dbspace
Enabling or Disabling Row-Level Versioning in a Table
Viewing or Modifying Base Table Properties
Viewing or Modifying Global Temporary Table Properties
Viewing and Modifying Proxy Table Properties
Authenticating a Login Account for a Managed Resource
Related reference
Table Privilege Summary