In the Data Replication Console, you can delete the virtual columns that you previously added to a replication configuration.
On the
Map Tables
tab, select the mapped source table to which you previously added the virtual column that you want to delete.
Click the
Show Virtual Columns
icon button above the source tables filter field, or right-click the source table row and click
Show Virtual Columns
.
The
Virtual Columns for <table_name>
dialog box appears.
Select the virtual column that you want to delete and click
Delete
.
A confirmation prompt appears.
Click
Yes
.
If other mapped source tables include virtual columns that have the same name, datatype, and properties as the one you deleted, the Data Replication Console asks if you want to delete the identical virtual columns in all of these tables or only the virtual column that you selected in step 3. Click one of the following options:
Yes
. Delete all of the identical virtual columns.
No
. Delete the single virtual column only.
To delete identical virtual columns from multiple tables selectively, select the virtual column row and click
Reuse
. Clear the
Select
check boxes for the tables from which you want to delete the virtual column and click