Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Drop permission for this table.PURGE RECYCLEBIN [recyele_table_name];
Parameter | Required | Description |
recyele_table_name | Optional | Specify the name of the table to be deleted. The name of the table is the alias after the table enters the recycle bin and can be obtained through the recycle_table field in SHOW RECYCLEBIN.If you fail to specify the name of the table in the bin, it means that the entire recycle bin will be purged. |
TDSQL [(none)]> show recyclebin;+-----------+---------------+--------------+--------------------------------+---------------------+---------------------+| tindex_id | origin_schema | origin_table | recycle_table | drop_time | purge_time |+-----------+---------------+--------------+--------------------------------+---------------------+---------------------+| 10028 | test | test1 | bin$tchgyzsnht3y0xtxlbitnq==$1 | 2025-01-21 19:12:10 | 2025-01-28 19:12:10 |+-----------+---------------+--------------+--------------------------------+---------------------+---------------------+TDSQL[(none)]> purge recyclebin `bin$tchgyzsnht3y0xtxlbitnq==$1`;Query OK, 0 rows affected (0.69 sec)
피드백