Welcome to Kofax Kapow > Design Studio > Interact with Databases > Create Database Tables

Create Database Tables

To store extracted variable values in a database, you create matching tables in the database. Design Studio can assist in creating these tables by examining the types you have created, and generating the appropriate SQL. When storing the value from a variable of some type, tables representing that type must be present in the database.

  1. In the Tools menu, select Create Database Table .

    The Create Database Table window appears.

  2. Enter a name for your database.
  3. Define the database type, and table types that you want to create.
  4. Click Generate SQL.

    The system suggests a SQL statement for creating the tables.

  5. Modify, execute, or save the statement.

    The SQL shown is a recommended suggestion: you can change the statement to fit your needs, if required. For example, you might change the column type for a Short Text attribute from "VARCHAR(255)" to "VARCHAR(50)" to conserve database space, or you could add an auto-incrementing primary key. However, under normal circumstances, you should not modify the table name or any column names, or remove any of the columns.

    Note If the database table already exists, it is dropped from the database when executing the SQL (because of the DROP TABLE statement at the beginning).