DROP ROLE (bSQL) | Blockpoint Docs
Drops a user role from the database. For examples, see Examples.
Syntax​
DROP ROLE { role_name }
Arguments​
role_name
Specifies the name of the role to be dropped.
Remarks​
Roles that have members cannot be dropped from the database. To drop a role that has members, you must first remove members of the role.
Permissions​
Requires AUTH permission on the database, or membership of admin fixed database role.
Examples​
The following example drops the database role purchasing from the database.
DROP ROLE purchasing