Updated on 2025-03-13 GMT+08:00

DROP RESOURCE LABEL

Description

Deletes a resource label.

Precautions

Only users with the POLADMIN or SYSADMIN permission, or the initial user can perform this operation.

Syntax

1
DROP RESOURCE LABEL [IF EXISTS] label_name[, ...];

Parameters

  • label_name

    Specifies the resource label name.

    Value range: a string. It must comply with the naming convention.

Examples

1
2
3
4
5
-- Delete a resource label.
gaussdb=# DROP RESOURCE LABEL IF EXISTS res_label1;

-- Delete a group of resource labels.
gaussdb=# DROP RESOURCE LABEL IF EXISTS res_label1, res_label2, res_label3;