Generating Domain DDL Commands

Display the data description language SQL code for adding a domain to the database. The SQL code is a useful reference and training tool.

Prerequisites
Database Version Domain Privileges
SAP Sybase IQ15.3 and 15.4 None required.
SAP Sybase IQ 16.0 None required.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane, select IQ Servers > Schema Objects > Domains.
  3. Select one or more domains 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.
    Tip: Use Shift-click or Control-click to select multiple domains.
    The DDL view shows the SQL code used to add the selected domains to the database.
Related tasks
Creating a Domain
Deleting a Domain
Viewing Domain Properties
Authenticating a Login Account for a Managed Resource
Related reference
Domain Privilege Summary