Syntax
The DROP ROLE statement has the following format:
[EXEC SQL] DROP ROLE role_id {, role_id};
role_id
Specifies an existing role identifier. If the list of role_ids contains any that do not exist, the DBMS Server returns an error for each non-existent role_id, but does not abort the statement. Others in the list that are valid, existing role identifiers, are removed.