功能描述
SHOW RECYCLEBIN 显示回收站内表信息。语法
SHOW RECYCLEBIN;
示例
TDSQL [(none)]> show recyclebin;+-----------+---------------+--------------+--------------------------------+---------------------+---------------------+| tindex_id | origin_schema | origin_table | recycle_table | drop_time | purge_time |+-----------+---------------+--------------+--------------------------------+---------------------+---------------------+| 10028 | test | test2 | bin$/usodaiwngrpdoel2wnlqg==$1 | 2025-01-21 19:12:10 | 2025-01-28 19:12:10 |+-----------+---------------+--------------+--------------------------------+---------------------+---------------------+
以上返回结果中的字段描述如下:
tindex_id:表唯一标识。origin_schema:原库名。origin_table:原表名。recycle_table:进入回收站后的别名。 drop_time:删除时间。 purge_time:清除时间(从回收站内清除)。