Icon DROP ROLE

Drops an existing role.

Syntax
DROP ROLE <Name>

Usage
Use this statement to drop a role.

Warning Dropping a role which has been assigned to existing users may mean that the users will cease to have the proper privileges required to complete their necessary tasks.

Examples
-- The following statement drops the Cashier role.

DROP ROLE "Cashier"

Required Privileges
The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
None
Image