sys.sp_droprole

Description

Removes a database role from the current database.

Syntax

sp_droprole [ @rolename = ]
N
'rolename'
[ ; ]

Remarks

Removes a database role from the current database.

The name of the database role to remove from the current database.

with no default.

must already exist in the current database.

(success) or

Only database roles can be removed by using

In SQL Server 2005 (9.x),

was replaced by the DROP ROLE statement.

is included only for compatibility with earlier versions of SQL Server and

might not be supported in a future release.

Examples

Example 1

sp_droprolemember

Example 2

sp_droprole

Example 3

ALTER
AUTHORIZATION

Example 4

sp_droprole

Example 5

CONTROL

Example 6

Sales

Example 7

EXECUTE sp_droprole
'Sales'
;
GO