v.23.3New Feature

Add system.dropped_tables for tracking incompletely removed dropped tables in Atomic databases

Add system.dropped_tables table that shows tables that were dropped from Atomic databases but were not completely removed yet. #47364 (chen).
Added the system.dropped_tables system table to display tables dropped from Atomic databases that have not been fully removed yet.

Why it matters

This feature helps users monitor tables that are in the process of being dropped but remain physically present in the database, providing insight into delayed or pending table removal operations and aiding in database maintenance and troubleshooting.

How to use it

Query the system.dropped_tables table using a SELECT statement to view information about tables dropped from Atomic databases but not yet completely removed, for example:

SELECT * FROM system.dropped_tables;