fix to make drop_schema_name usable and test pass

[axellpadilla]

Use default target database when passed only the schema name so subsequent macros can use it.

This will enable this test and the functionality. All tests passing.