Generating Dbspace DDL Commands

Display the data description language SQL code for creating a dbspace. The SQL code can be a useful reference and training tool.

  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane of the Administration Console, expand IQ Servers > Space Management and select Dbspaces.
  3. In the right pane, select a dbspace.
  4. Click the drop-down arrow that appears next to the dbspace name and select Generate DDL.
    The DDL window opens, showing the SQL code used to create the selected dbspace.
Related tasks
Viewing Dbspace Properties
Adding a Dbspace
Modifying a Dbspace
Changing a Dbspace to Read-Only
Preallocating Space for a Dbspace
Deleting a Dbspace