Question

What does Fivetran do with a synced table that gets dropped in the source system?

Answer

As a core principle, we do not delete any data from your destination. When a table is dropped in the source, the table will remain in the destination but will no longer be updated. 

Cause

Dropping a table in the source.