DB Table Deleter

This node removes a table with the given name from the database described by the incoming DB Connection. This is usually done by executing the SQL command drop.

Options

Database name

The name of the database (or catalogue) to use.

Schema name

The database schema to read the table from.

Table name

Name of the database table to read data from. Must match the table name as it appears in the selected schema.

If table does not exist

The behavior if the selected table does not exist.

• Ignore: Skip the deletion of non-existent tables silently.
• Fail: Throw an error and abort node execution.

If other tables have relations to this table

The behavior if other tables have relations to the selected table.

• Ignore: Don't drop the table from the database.
• Delete all related tables: Delete the selected table and all related tables, recursively. This also removes any data in those tables - use with caution!
  The option is ignored if it is not supported by the database e.g. DB2, Hive, Impala or SQLite.

Views

This node has no views

Workflows

• 01 Practicing with Traditional DatabasesKNIME Hub
• 01 Practicing with Traditional Databases - SolutionKNIME Hub
• 01 Practicing with Traditional Databases - SolutionKNIME Hub
• 01 Practicing with Traditional Databases - SolutionKNIME Hub
• 01 Practicing with Traditional Databases - SolutionKNIME Hub
• Show all 256 workflows

Links

• No links available

Developers