metadata/bug: dropping table from console does not delete its corresponding metadata file

### Version Information

Server Version: 2.11.1
CLI Version (for CLI related issue):v3

### Environment
OSS

### What is the current behaviour?
Currently, when I drop a table from DB, it does not remove its metadata related file in metadata directory. That is `metadata/databases//tables/_.yaml` this file still exists

### What is the expected behaviour?
It should remove the dropped/deleted table's metadata related file from metadata directory

### How to reproduce the issue?

1. Spin up docker image and open console
2. Delete table from console UI
3. Check relevant table's metadata files in metadata directory ( `metadata/databases//tables/_.yaml` )

### Screenshots or Screencast
Here, I had deleted `test_2` table from console prior to this screenshot capture

### Can you identify the location in the source code where the problem exists?

Nope as I am not familiar with the codebase

### If the bug is confirmed, would you be willing to submit a PR?

I guess "no", because of unfamiliarity with codebase

### Keywords
drop , metadata , table

### Additional notes
Also, if this is an expected behaviour , can you confirm it ?