UNDROP TABLE

Restores the recent version of a dropped table.

See also:

• CREATE TABLE
• DROP TABLE
• SHOW TABLES

Syntax

UNDROP TABLE [db.]name

tip

• If a table with the same name already exists, UNDROP will get the error: ERROR 1105 (HY000): Code: 2308, Text = Undrop Table 'test' already exists.
• UNDROP relies on the Databend time travel feature, the table can be restored only within a retention period, default is 24 hours.

Examples

CREATE TABLE test(a INT, b VARCHAR);

-- insert data
INSERT INTO test VALUES(1, 'a');

-- check
SELECT * FROM test;
+------+------+
| a    | b    |
+------+------+
|    1 | a    |
+------+------+

-- drop table
DROP TABLE test;

SELECT * FROM test;
ERROR 1105 (HY000): Code: 1025, Text = Unknown table 'test'.

-- un-drop table
UNDROP TABLE test;

-- check
SELECT * FROM test;
+------+------+
| a    | b    |
+------+------+
|    1 | a    |
+------+------+