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

DROP RESOURCE LABEL

Description

Drops 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

Examples

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

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

Helpful Links

ALTER RESOURCE LABEL and CREATE RESOURCE LABEL

Parent topic: SQL Syntax