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 dropped.
Value range: an existing role name.
Examples
See Examples in "CREATE ROLE."
Helpful Links
CREATE ROLE, ALTER ROLE, and SET ROLE
Parent topic: SQL Syntax
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
