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;