DROP SNAPSHOT

语法说明

DROP SNAPSHOT 用于删除当前租户下创建的快照。

语法结构

> DROP SNAPSHOT snapshot_name;

示例

create snapshot sp1 for account sys;

mysql>  show snapshots;
+---------------+----------------------------+----------------+--------------+---------------+------------+
| SNAPSHOT_NAME | TIMESTAMP                  | SNAPSHOT_LEVEL | ACCOUNT_NAME | DATABASE_NAME | TABLE_NAME |
+---------------+----------------------------+----------------+--------------+---------------+------------+
| sp1           | 2024-05-10 09:55:11.601605 | account        | sys          |               |            |
+---------------+----------------------------+----------------+--------------+---------------+------------+
1 row in set (0.01 sec)

drop snapshot sp1;

mysql>  show snapshots;
Empty set (0.01 sec)