v.20.5Improvement

Remove DROP DATABASE Data for Memory Engine

Remove data on explicit DROP DATABASE for Memory database engine. Fixes #10557. #11021 (tavplubix).
Removed data deletion on explicit DROP DATABASE command for the Memory database engine in ClickHouse.

Why it matters

This change fixes an issue where data from Memory engine databases was improperly removed when executing DROP DATABASE. By preventing data removal on drop, it avoids accidental data loss and aligns behavior with expected use for in-memory databases.

How to use it

Users simply execute the DROP DATABASE command as usual on databases with the Memory engine. The data will no longer be deleted explicitly on drop.