You can execute the SHOW RECYCLEBIN statement to query for objects in the recycle bin.
Considerations
You can delete tenants only in the sys tenant. Therefore, user tenants can be moved only to the recycle bin of the sys tenant after they are dropped. Tenants can be dropped forcibly or non-forcibly. For more information, see DROP TENANT. In the sys tenant, you can view databases, tables, and indexes of the current tenant as well as those of all other tenants in the recycle bin. In a user tenant, you can view only databases, tables, and indexes in the recycle bin.
Background information
When you drop a database object or tenant:
If the recycle bin is enabled, the object is moved to the recycle bin and can be viewed in the recycle bin.
If the recycle bin is disabled, the object is not moved to the recycle bin and cannot be viewed in the recycle bin.
Procedure
Log in to the database as the tenant administrator of the
systenant or a user tenant.Note
- The tenant administrator is the
rootuser. - To view tenant recycle bin objects, you must log in to the database as the
systenant.
Here is an example of the connection command. Use the actual database connection information in your production environment.
obclient -h10.xx.xx.xx -P2883 -uroot@sys#obdemo -p***** -AFor more information about how to connect to a database, see Overview of connection methods.
- The tenant administrator is the
Execute the following statement to view the objects in the recycle bin.
obclient [(none)]> SHOW RECYCLEBIN; +-------------------------------------+-------------------+--------+----------------------------+ | OBJECT_NAME | ORIGINAL_NAME | TYPE | CREATETIME | +-------------------------------------+-------------------+--------+----------------------------+ | RECYCLE_$_100017_1672050541224936 | mysql001 | TENANT | 2023-01-16 11:01:40.258000 | | __recycle_$_100017_1673426335319344 | __idx_500788_idx1 | INDEX | 2023-01-11 16:38:55.318878 | | __recycle_$_100017_1673426335329040 | __idx_500788_idx2 | INDEX | 2023-01-11 16:38:55.328312 | | __recycle_$_100017_1673426335331800 | t1 | TABLE | 2023-01-11 16:38:55.331481 | +-------------------------------------+-------------------+--------+----------------------------+ 4 rows in setThe relevant fields in the query result are described as follows:
OBJECT_NAME: The name of the object in the recycle bin.ORIGINAL_NAME: The original name of the object.TYPE: The type of the recycle bin object. Valid values:The system tenant (
systenant) supports theINDEX,TABLE,DATABASE, andTENANTtypes. In this example,mysql001is a tenant-type recycle bin object.User tenants support three types:
INDEX,TABLE, andDATABASE.
CREATETIME: The time when the object was moved to the recycle bin.
References
For more information about the recycle bin, see the following topics: