602SQL Documentation Index  

DROP ROLE Statement

statement_DROP_ROLE ::= DROP [ IF EXISTS ] ROLE [ schema. ] role_name

The DROP ROLE statement deletes a role of the role_name name in the specified schema. If the schema is not specified, the active schema is used.

If a domain of the specified name does not exist in the schema, the statement does not execute any action if the IF EXISTS clause is used, otherwise the error sqlstate W0137 (OBJECT_DOES_NOT_EXIST) occurs.

When a role is deleted, all role relations are deleted.