DROP ROLE statement 

The DROP ROLE statement (drop_role_statement) drops a role.

Syntax

<drop_role_statement> ::= DROP ROLE <role_name>

Examples

SQL Tutorial, Roles

Explanation

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.