Skip to main content

SHOW DROP TABLES

Introduced: v1.2.10

Lists the dropped tables in the current or a specified database.

Syntax

SHOW DROP TABLES [FROM <database_name>]

Examples

USE database1;

-- List dropped tables in the current database
SHOW DROP TABLES;

-- List dropped tables in the "default" database
SHOW DROP TABLES FROM default;

Name |Value |
--------------------+-----------------------------+
tables |t1 |
table_type |BASE TABLE |
database |default |
catalog |default |
engine |FUSE |
create_time |2023-06-13 08:43:36.556 +0000|
drop_time |2023-07-19 04:39:18.536 +0000|
num_rows |2 |
data_size |34 |
data_compressed_size|330 |
index_size |464 |
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today