Changing the schema of a table

The Fix Schema action allows you to perform multiple data transformations to a table's structure in a single step. You can:

• Add a new column to the target table
• Mark columns for deletion to remove columns
• Copy the schema to use an existing table as a template
• Alter the data type of one or more columns

1. Click to add a new column.

2. Click to use an existing table as a template.

3. Click a field to change its value.

4. Select to reseed if no change is made.

The most common application is to fix the structure of a target table.

Fix a table schema

1. Drag the Fix Schema icon onto the design surface.
2. On the Connections tab , enter a Name and a Description to identify the action, then select the database and table.
   • Database Connection – Select the database that contains the table being fixed, or choose New Database Connection to establish a new connection.
   • Table Name – Enter the name of the table being fixed.
3. On the Configuration tab :
   • To use an existing table as a template, click Copy Schema, and select the Database Connection and Table Name of the existing table when prompted.
   • Click the Add icon to add a new column, then enter or select values for the column.
   • Click on a field to change its value -
     • Column Name – Specify the new name of the column.
     • Data Type – Select a new data type for the column.
     • Seed Value – Specify a new seed value of the column.
     • Reseed – Select the checkbox to repopulate the column with its seed value if the action is executed but no change is made.
     • Status – Click the Delete icon in this field to mark a column for deletion. For any column being added or altered, this field also displays an icon indicating the nature of the change, and you can hover over the icon for the details of the change.
   • Click on the Delete icon next to the Add icon to remove all columns from the list.

Fix Schema data example

In the following example, the Description column is deleted, and a new column Status is added of data type StringU and a seed value of Active.