This statement removes a role from the database. When you drop a role, it is revoked from all users and roles to whom it has been granted and removed from the database.
To support DROP ROLE processing, the IP GETSUPPORT operation must return TRUE for IP_SUPPORT_DROP_ROLE.