• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. DROP ROLE

DROP ROLE

Function

DROP ROLE deletes a specified role.

Precautions

None.

Syntax

DROP ROLE [ IF EXISTS ] role_name [, ...];

Parameter Description

  • IF EXISTS

    Sends a notice instead of an error if the specified role does not exist.

  • role_name

    Specifies the name of the role to be deleted.

    Value range: An existing role.

Examples

See Examples in CREATE ROLE.

Helpful Links

CREATE ROLEALTER ROLESET ROLE