DROP TABLESPACE needs to be consistent with DROP TABLE if the IBD file is missing.
It needs to ignore the fact that the IBD file is missing and delete the dictionary metadata.

Approved by Marko in RB#11984