DROP ROLE Statement (drop_role_statement)
The DROP ROLE
statement (drop_role_statement
)
deletes a role.
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.