On this page

Function
Precautions
Syntax
Parameter Description
Examples

Show all

Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-3.x)/ SQL Reference/ SQL Syntax/ DROP CLIENT MASTER KEY

DROP CLIENT MASTER KEY

Updated on 2024-05-07 GMT+08:00

View PDF

Function

DROP CLIENT MASTER KEY deletes a CMK.

Precautions

Only the CMK owner or a user who has been granted the DROP permission can run this command. By default, the system administrator has this permission.
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

    
       DROP CLIENT MASTER KEY [ IF EXISTS ] client_master_key_name [, ...] [ CASCADE | RESTRICT ];

Parameter Description

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

    
       -- 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

Previous topic: DROP AUDIT POLICY

Next topic: DROP COLUMN ENCRYPTION KEY

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank 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.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback

Log In and Submit Submit Cancel