Allow users to pass a purge flag as an option and use it in the drop table and drop namespace operations.