Drops an existing secret. Secrets cannot be dropped if they are referenced by an active query.
The name of the Secret to drop. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.
db1.public/my_store# DROP SECRET mysecret;
+------------+------------+------------+------------------------------------------+
| Type | Name | Command | Summary |
+============+============+============+==========================================+
| secret | mysecret | DROP | secret "mysecret" has been marked for |
| | | | deletion |
+------------+------------+------------+------------------------------------------+
db1.public/my_store# LIST SECRETS;
+------------+------------+--------------+----------------+------------+------------+-------------+-------------+
| Name | Type | Description | Access Region | Status | Owner | Created At | Updated At |
+============+============+==============+================+============+============+=============+=============+
+------------+------------+--------------+----------------+------------+------------+-------------+-------------+