The DROP ROLE statement (drop_role_statement) deletes a role.
Syntax
<drop_role_statement> ::= DROP ROLE <role_name>
SQL Tutorial, Roles
The current database user must be the owner of the role. The metadata of the role to be dropped is dropped from the database catalog.