Help Center/ GaussDB/ Developer Guide(Centralized_3.x)/ SQL Reference/ SQL Syntax/ DROP CLIENT MASTER KEY
Updated on 2024-05-07 GMT+08:00
View PDF
Share

DROP CLIENT MASTER KEY

Description

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 delete the metadata of key objects recorded in the system catalog of the database, but cannot delete the key entities managed by the client key tool or online key service.

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

  • 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 CLIENT MASTER KEY
Parent topic: SQL Syntax