UNROP TABLE
描述
UNDROP TABLE 恢复之前使用 DROP TABLE 删除的表及其关联的目录（如果表不是 EXTERNAL 表）。如果表未被删除，则抛出异常。
对于外部表，仅从元存储数据库中删除关联的元数据信息。
如果表已缓存，则命令将取消缓存表及其所有依赖项。
语法
UNDROP TABLE ( table_identifier | WITH ID table_id )Parameter
table_identifier
指定被删除的表名，可以选择使用数据库名进行限定。
语法:
[ database_name. ] table_nametable_id
指定被删除的表的 ID，表的 ID 可以通过
SHOW TABLES等语句查询。
示例
-- 假设存在一个名为 `employeetable` 的被删除的表。
SHOW TABLES DROPPED;
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
|database| tableName|tableType|tableId|size| createdAt| deletedAt|isShared|isDeleted|description|
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
| default|employeetable| table| 1| 20|2024-10-10 19:27:...|2024-10-10 19:28:...| false| true| |
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
-- 恢复此表
UNDROP TABLE employeetable;
-- 确认被恢复
SHOW TABLES DROPPED;
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
|database|tableName|tableType|tableId|size|createdAt|deletedAt|isShared|isDeleted|description|
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
-- 删除表
DROP TABLE employeetable;
SHOW TABLES DROPPED;
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
|database| tableName|tableType|tableId|size| createdAt| deletedAt|isShared|isDeleted|description|
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
| default|employeetable| table| 1| 20|2024-10-10 19:27:...|2024-10-10 19:28:...| false| true| |
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
-- 使用 ID 恢复表
UNDROP TABLE WITH ID 1;
-- 确认被恢复
SHOW TABLES DROPPED;
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
|database|tableName|tableType|tableId|size|createdAt|deletedAt|isShared|isDeleted|description|
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+