Support for database atomic wait options in DROP DATABASE command

Why it matters

This feature addresses the need for users to perform DROP DATABASE operations synchronously, ensuring that the database drop and detach operations complete before the command returns. It improves reliability and predictability in database management tasks where immediate confirmation of the drop is required.

How to use it

Users can enable synchronous dropping of databases by setting the database_atomic_wait_for_drop_and_detach_synchronously setting to 1 or by appending NO DELAY or SYNC to the DROP DATABASE query, for example:

DROP DATABASE dbname NO DELAY;

or

DROP DATABASE dbname SYNC;