Description
Contains information about tables that drop table has been executed on but for which data cleanup has not yet been performed.
Columns
index (UInt32) — Index in marked_dropped_tables queue.database (String) — Database name.table (String) — Table name.uuid (UUID) — Table UUID.engine (String) — Table engine name.metadata_dropped_path (String) — Path of table’s metadata file in metadata_dropped directory.table_dropped_time (DateTime) — The time when the next attempt to remove table’s data is scheduled on. Usually it’s the table when the table was dropped plus database_atomic_delay_before_drop_table_sec.
This table lists only tables dropped from Atomic databases. For these tables, table_dropped_time is normally based on database_atomic_delay_before_drop_table_sec. For a Shared database in ClickHouse Cloud, the recovery period is instead controlled by database_shared_drop_table_delay_seconds, which defaults to 8 hours; dropped tables from Shared databases don’t appear in system.dropped_tables.
Example
The following example shows how to get information about dropped_tables.
Last modified on August 3, 2026
