Creates a lookup table containing values stored in a column and creates a foreign key to the new table.

Available attributes

Name Description Required for Supports
constraintName Name of the foreign-key constraint to create between the existing table and the lookup table all
existingColumnName Name of the column containing the data to extract all all
existingTableCatalogName all
existingTableName Name of the table containing the data to extract all all
existingTableSchemaName all
newColumnDataType Data type of the new table column informix, mariadb, mssql, mysql all
newColumnName Name of the column in the new table to create all all
newTableCatalogName all
newTableName Name of lookup table to create all all
newTableSchemaName all

Database support

Database Notes Auto Rollback
DB2/LUW Supported Yes
DB2/z Supported Yes
Derby Supported Yes
Firebird Not Supported No
H2 Supported Yes
HyperSQL Not Supported No
INGRES Supported Yes
Informix Supported Yes
MariaDB Supported Yes
MySQL Supported Yes
Oracle Supported Yes
PostgreSQL Supported Yes
Snowflake Supported Yes
SQL Server Supported Yes
SQLite Not Supported No
Sybase Supported Yes
Sybase Anywhere Supported Yes