Generating DB File DDL Commands

Display the data description language SQL code for adding a DB file to 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 DB Files.
3. In the right pane, select a DB file.
4. Click the drop-down arrow that appears next to the DB file name and select Generate DDL.
   The DDL tab shows the SQL code used to add the selected DB file to the dbspace.