Create database table from types

To store extracted variable values in a database, you can create a matching database table. To create a database table from one or more types uploaded to Management Console, follow this procedure.

  1. Select a type in Repository > Types.
  2. Click the context menu for the type and click Create database table.

    The Create table dialog box appears.

  3. In the Create table dialog box, select one of the configured database mappings defined in a project and select whether to generate SQL code to drop tables. Click Generate SQL.

    The SQL editor opens, containing SQL code to generate (and drop if you selected Generate SQL to drop tables) the tables from the selected types on the selected database. The SQL shown is a recommended suggestion: You can change the statement to fit your needs, if required. When ready, click Execute SQL.

    After the SQL code is executed, a message is issued with an execution state (success or errors with description). Click OK to dismiss the message and close the windows.