Datasource Alter Table

Impure

Alters an existing table to match the datasource mapping: adds missing columns, optionally drops extras.

Pure Function

No

Execute Inputs

Execution

INPUT

Execution Input.

Execute Outputs

Complete

OUTPUT

Fired when alteration completes.

Data Inputs

Datasource

INPUT

Name of the datasource to use.

Table Name

INPUT

The name of the SQL table to alter.

Mapping

INPUT

The datasource mapping to use for altering the table.

Execute

INPUT

Whether to actually execute the ALTER TABLE SQL or just return it.

Data Outputs

Generated SQL

OUTPUTstring

The ALTER TABLE SQL generated.

Multiple

Settings

Remove Extra Columns

BOOLEAN

If true, columns in the table but not in the mapping will be dropped.

Default: false

Throw on SQL Error

BOOLEAN

If true, will throw an error if a SQL error occurs during query.

Default: true

Debug

STRING

Break on node when executing.

Default: No

Options:

NoBeforeInputsBeforeProcessingAfterProcessing