Updated on 2025-08-19 GMT+08:00
DROP ROLE
Description
Drops a role.
Syntax
DROP ROLE [ IF EXISTS ] role_name [, ...];
Parameters
- IF EXISTS
Reports a notice instead of an error if the specified role does not exist.
- role_name
Specifies the name of the role to be deleted.
Value range: an existing role name
Examples
See Examples in section "CREATE ROLE."
Helpful Links
CREATE ROLE, ALTER ROLE, and SET ROLE
Parent topic: SQL Syntax
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
