Generating Dbspace DDL Commands

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

  1. In the Perspective Resources view, highlight the resource and select Resource > Administration Console.
  2. In the left pane of the Administration Console view, select IQ Servers > Space Management > Dbspaces.
  3. In the Dbspaces view, highlight a dbspace.
  4. Hover the mouse pointer over the dbspace name and click the arrow.
  5. Select Generate DDL.
    The DDL tab 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