v.23.3New Feature

Support for UNDROP TABLE Query

Support for UNDROP TABLE query. Closes #46811. #47241 (chen).
Support for <code>UNDROP TABLE</code> query.

Why it matters

This feature allows users to restore tables that were previously dropped, addressing accidental data loss or enabling recovery scenarios. It adds safety and flexibility in managing tables by making it possible to undo a drop operation.

How to use it

To use this feature, execute the <code>UNDROP TABLE</code> query specifying the name of the table you want to restore, for example:

UNDROP TABLE table_name;

This command will recover the recently dropped table if it is available for undropping.