In Workgen, there is one function that drops tables: start_table_idle_cycle. This one has a very specific and isolated use case though, it creates a table, opens a cursor and directly drops the table.
As part of PM-2712, one of the requirements is to be able to drop a table at any time.
This ticket needs to update Workgen so an existing table can be dropped safely while updating the internal variables in Workgen (see WT-10238). This could be done through a simple API called remove_table. The Python interface should be updated as well.
The locking mechanism mentioned in WT-10238 should be reused if this ticket is implemented after.