Feature for removing all tables that are not used by current models

[JavierLopezT]

There are some cases in which all the tables we have in our database are fully managed by dbt, either in the form of seeds, sources or tables/views.

Sometimes I make changes that leave old tables/views behind (like changing the name of a seed) and it would be nice to have a command like:

dbt sync

That removes all the old tables.

There have been custom solutions to that in threads like:
https://discourse.getdbt.com/t/clean-your-warehouse-of-old-and-deprecated-models/1547/10
https://discourse.getdbt.com/t/faq-cleaning-up-removed-models-from-your-production-schema/113/13

But I think it would be nice to have it as a core feature.

What do you think?

[jtcohen6]

@JavierLopezT Check out this proposal & in-progress work:

• [CT-426] [Feature] Manage full schema content with dbt by dropping tables/views not maintained in models #4957
• Feature CT-426 manage schemas #5392

[alison985]

This at least semi-relates to #8194 FYI @damian3031