Hub
Pricing About
NodeNode / Source

Database Table Creator (deprecated)

This node has been deprecated and its use is not recommended. Please search for updated nodes instead.

Like

This node is part of the deprecated database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation .

This node allows a user to create a new database table either manually or based on the data table spec of an input data table (see "Use dynamic settings" below). The node supports advanced options such as null or not null, primary key or unique keys, default SQL type mapping based on column name or KNIME data type, and default key definitions based on column names.

Tick the "Use dynamic settings" option to enable the dynamic settings behavior. Once enable it allows to dynamically define the SQL type of the columns as well as the assignment of columns to primary or unique keys. All dynamic settings which are made via the Dynamic Type Settings and Dynamic Column Settings tab are applied to the data table specification of the input data table. The mappings defined in the Name-Based SQL Type Mapping have a higher priority than the mappings defined in the KNIME-Based SQL Type Mapping. If no mapping is defined in both Name-Based SQL Type mapping and KNIME-Based SQL Type Mapping, then the default mapping is used. While in dynamic settings mode the "Columns" and "Keys" tab become read-only to allow you a preview of the dynamic settings.

Node details

Input ports
  1. Type: Database Connection
    Database Connection
    A database connection to connect to the database.
  2. Type: Table
    Datatable
    An optional data table whose data table spec should be used to create the new database table.
Output ports
  1. Type: Database Connection
    Database Connection
    The input database connection including flow variables with the schema and table name of the new created database table

Extension

The Database Table Creator (deprecated) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits