"Destroy" a connection to drop all destination tables

[vijaybridgeme]

Tell us about the problem you're trying to solve

When I reset a connection, I see the data in the final table is deleted. Is there a way to delete the tables as well?
When I delete the connection, I don't see the tables being dropped (deleted.)

This means to keep the destination database clean, the application needs to track which tables Airbyte creates, like "_airbyte_raw" and "_scd"; and delete them explicitly. This logic would be unreliable since application may not be aware of all the tables Airbyte would create.

Describe the solution you’d like

Provide a "destroy" connection API to drop the tables and restore the destination database to pristine state, with no lingering tables.

Describe the alternative you’ve considered or used

Alternative is to cleanup in application code.

Additional context

Add any other context or screenshots about the feature request here.

Are you willing to submit a PR?

not for this one! sorry!