Modifying a derived column

You can make modifications to an existing derived column.

1. Click Configuration > Subscriptions.
2. Select the subscription.
3. Click the Table Mappings view and select the table mapping from the Source Table column.
4. Right-click and select Open Details....
5. Click the Column Mappings tab.
6. Expand the Source Columns list, select and right-click on an existing derived column and click Modify Derived Column.
7. Make the necessary changes and click OK.
8. Click Verify to ensure the expression is valid.
9. Click Save.

Results

When you start replication on the subscription, CDC Replication populates the target column with the results stored in the derived column.