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

DROP RESOURCE LABEL

Function

DROP RESOURCE LABEL 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[, ...];

Parameter Description

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 resource label.
gaussdb=# DROP RESOURCE LABEL IF EXISTS res_label1, res_label2, res_label3;