Skip to content

USER_RECYCLEBIN

功能描述

USER_RECYCLEBIN系统视图用于查询当前用户的所有回收站对象。

字段说明

字段名类型说明
DB_IDINTEGER库ID
USER_IDINTEGER所有者ID
OBJECT_IDINTEGER对象ID
RELATEDOBJ_IDINTEGER父对象ID
OBJECT_TYPEINTEGER对象类型
OBJECT_TYPE_NAMEVARCHAR对象类型名
SCHEMA_IDINTEGER模式ID
OBJECT_NAMEVARCHAR对象原名
RECYCLE_NAMEVARCHAR回收站唯一名
DROPED_TIMEDATETIME删除时间
CAN_UNDROPVARCHAR是否可以从回收站恢复
CAN_PURGEVARCHAR是否可以删除
RESERVED1VARCHAR保留字段

示例

sql
SQL> SELECT * FROM USER_RECYCLEBIN;

DB_ID | USER_ID | OBJECT_ID | RELATEDOBJ_ID | OBJECT_TYPE | OBJECT_TYPE_NAME | SCHEMA_ID | OBJECT_NAME | RECYCLE_NAME | DROPED_TIME | CAN_UNDROP | CAN_PURGE | RESERVED1 |
------------------------------------------------------------------------------
1 | 101 | 1048625 | 1048625 | 5 | Table| 101 | INDEX_TABLE3| BIN$080001000B| 2024-01-08 13:41:43.262 AD | YES| YES| <NULL>|
1 | 101 | 1048626 | 1048625 | 10 | Index| 101 | PK_IDX_S1904517047212935| BIN$0E0000000E| 2024-01-08 13:41:43.262 AD | NO| YES| <NULL>|

Total 2 records.
Use time:1 ms.