Help Center/
GaussDB/
Developer Guide(Distributed_V2.0-3.x)/
SQL Reference/
SQL Syntax/
DROP CLIENT MASTER KEY
Updated on 2025-03-13 GMT+08:00
DROP CLIENT MASTER KEY
Description
Drops a CMK.
Precautions
- Only the CMK owner or a user who has been granted the DROP permission can run this command. System administrators have this permission by default.
- This command can only be used to delete the metadata information recorded in the system catalog of the database, but cannot be used to delete the CMK file. You need to use KeyTool to delete the CMK file.
Syntax
1
|
DROP CLIENT MASTER KEY [ IF EXISTS ] client_master_key_name [, ...] [ CASCADE | RESTRICT ]; |
Parameters
- IF EXISTS
If a specified CMK does not exist, a notice rather than an error is issued.
- client_master_key_name
Name of a CMK to be deleted.
Value range: a string. It is the name of an existing CMK.
- CASCADE | RESTRICT
Allows/Restricts to delete objects that depend on the CMK.
Examples
1 2 3 4 |
-- Delete a CMK object. gaussdb=> DROP CLIENT MASTER KEY ImgCMK CASCADE; NOTICE: drop cascades to column setting: imgcek DROP GLOBAL SETTING |
Parent topic: SQL Syntax
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot