adapter-specific `drop_tables` helper

This moves the adapter-specific behavior in `drop_tables` into the
adapters.  Right now it is only supported in the Postgres adapter.