tencent cloud

TDSQL Boundless

DocumentaçãoTDSQL BoundlessGeneral ReferenceSQL ReferenceSQL StatementsPURGE RECYCLEBIN

PURGE RECYCLEBIN

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 2026-02-10 11:27:31

Description

To clear a table in the recycle bin, you need to provide the name of the table in the bin.
If you fail to specify the name of the table in the bin, it means that the entire recycle bin will be purged.

Permission Requirements

You should have the Drop permission for this table.

Syntax

PURGE RECYCLEBIN [recyele_table_name];

Parameter Description

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.

Examples

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)

Anterior: OPTIMIZE TABLEPróximo: SAVEPOINT

Ajuda e Suporte

Esta página foi útil?

comentários