Updated on 2024-06-03 GMT+08:00

DROP ROLE

Function

Deletes a role.

Syntax

DROP ROLE [ IF EXISTS ] role_name [, ...];

Parameter Description

  • 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