Summary

When dropping tiered tables, we only want to drop the local content. The dropping of the shared objects will happen during garbage collection. That means that a drop will remove the local writable object and all metadata referencing the table including the metadata for objects that will still exist on the shared storage.

The work for implementing drop was completed in WT-7375. There is a basic test for drop in test_tiered07.py. That test should be expanded to include testing all possible configurations for drop and making sure tiered storage does the right thing for each one.

Acceptance Criteria (Definition of Done)
We need to test both options "force" and "remove_files". We need to make sure that metadata entries are removed and the corresponding files are deleted, or not deleted if remove_files=false.

Shared files must not be deleted. There should be a test for that too.