# DROP ROLE

The `DROP ROLE` command removes a role from a SingleStore cluster.

## Syntax

```
DROP ROLE [IF EXISTS] 'role_name'

```

## Remarks

* `IF EXISTS` is available in 6.0.15 or later.
* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

## Example

```sql
SHOW ROLES;

```

```output

+-------------+
| Roles       |
+-------------+
| role_name_0 |
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
4 rows in set (0.00 sec)

```

```sql
DROP ROLE 'role_name_0';

SHOW ROLES;

```

```output

+-------------+
| Roles       |
+-------------+
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
3 rows in set (0.00 sec)
```

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/security-management-commands/drop-role/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/drop-role/)

(An index of the documentation is available at /llms.txt)