Check if a column exists
- Former user (Deleted)
Owned by Former user (Deleted)
Description
This steps allows you to verify the existence of a specific column in a database table.
Options
Option |
Description |
|---|---|
Step name |
Name of the step; This name has to be unique in a single transformation |
Connection |
The database connection to use |
Schema name |
(optional) The schema name of the table of the column to check |
Table name |
The name of the table of the column to check |
Tablename in field? |
Enable to read the name of the table in an input field |
Tablename field |
Specify the fieldns containing parameters and the parameter type |
Columnname field |
The name of the column field in the input stream |
Result fieldname |
The name of the resulting boolean flag field |
Example
 samples/transformations/Check if a column exists - Basic example.ktr