Question

You want to turn off sync for certain columns in a table or deselecting the table entirely and want to know what happens to the metadata and data existing in those columns/tables in your destination.

Answer

If a column or table is deselected from the sync, the metadata and data related to that column or table will remain untouched in your destination. You will need to manually delete the data from your destination if you want it removed.