> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8a08bda2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing information about tables that drop table has been executed on but for which data cleanup has not yet been performed

# system.dropped_tables

<h2 id="description">
  Description
</h2>

Contains information about tables that drop table has been executed on but for which data cleanup has not yet been performed.

<h2 id="columns">
  Columns
</h2>

* `index` ([UInt32](/reference/data-types)) — Index in marked\_dropped\_tables queue.
* `database` ([String](/reference/data-types)) — Database name.
* `table` ([String](/reference/data-types)) — Table name.
* `uuid` ([UUID](/reference/data-types)) — Table UUID.
* `engine` ([String](/reference/data-types)) — Table engine name.
* `metadata_dropped_path` ([String](/reference/data-types)) — Path of table's metadata file in metadata\_dropped directory.
* `table_dropped_time` ([DateTime](/reference/data-types)) — 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`.

<h2 id="example">
  Example
</h2>

The following example shows how to get information about `dropped_tables`.

```sql theme={null}
SELECT *
FROM system.dropped_tables\G
```

```text theme={null}
Row 1:
──────
index:                 0
database:              default
table:                 test
uuid:                  03141bb2-e97a-4d7c-a172-95cc066bb3bd
engine:                MergeTree
metadata_dropped_path: /data/ClickHouse/build/programs/data/metadata_dropped/default.test.03141bb2-e97a-4d7c-a172-95cc066bb3bd.sql
table_dropped_time:    2023-03-16 23:43:31
```