title: "DROP ROLE"
description: "DROP ROLE
removes a role from Materialize."
menu:
main:
parent: commands
DROP ROLE
removes a role from Materialize.
{{< diagram "drop-role.svg" >}}
Field | Use |
---|---|
IF EXISTS | Do not return an error if the specified role does not exist. |
_rolename | The role you want to drop. For available roles, see mz_roles . |
You cannot drop the current role.
The privileges required to execute this statement are:
{{< include-md file="shared-content/sql-command-privileges/drop-role.md" >}}