DROP ROLE (TSQL Statement)
deletes the specified role from the current database.
Syntax
DROP ROLE role_name
Arguments
- role_name
- is the name of the role to drop.
Remarks
Only sa or dbo is allowed to execute this statement.
All permissions for this role are also deleted.
Examples
DROP ROLE accounting;