› 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.

Do not use reserved names in your variable names to avoid database errors. See Naming policy for details.

  1. Open a robot or a type and on the Tools menu, select Create Database Table .

    The Create Database Table window appears.

    If you use Kofax RPA built-in development database, start the database before creating database tables. To start the database, right-click the Development Database item under Design Studio Databases and select Start Local Development Database.

  2. Select a database from the Database list. The list contains created databases. See Map Databases for information on how to create a database.
  3. Select the type for which you want to create a database table.
  4. Click Generate SQL.

    The system suggests a SQL statement for creating the tables.

  5. Select Drop table if exists if you want to recreate tables in the existing database by including a 'DROP TABLE' statement before each 'CREATE TABLE' statement to make sure the corresponding table is removed if it already exists.
  6. 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.