Wait for DROP/DETACH TABLE to Complete with NO DELAY or SYNC in Atomic Database

Why it matters

This feature ensures synchronous behavior for table drop or detach commands in Atomic databases when users specify NO DELAY or SYNC. It guarantees that these operations are fully finished before returning control, improving consistency and predictability of database state changes.

How to use it

When using DROP TABLE or DETACH TABLE on an Atomic database, add the NO DELAY or SYNC keyword to the query to enable blocking until the operation completes. For example:

DROP TABLE db.table NO DELAY;
-- or
DETACH TABLE db.table SYNC;