Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-3.x)/ SQL Reference/ SQL Syntax/ DROP RESOURCE LABEL
Updated on 2025-08-19 GMT+08:00
View PDF

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;

Helpful Links

ALTER RESOURCE LABEL and CREATE RESOURCE LABEL

Parent topic: SQL Syntax