DROP ROLE

Delete a role from the database.

Syntax
      DROP ROLE role

Key
   role     The role to drop. 

Roles that have members and fixed database roles cannot be dropped from the database.

Examples

DROP REMOTE SERVICE BINDING MyBinding ;

“I don’t know if I believe in role models. We're all so different; we’re all individuals. In the long run, that's what matters” ~ Wilson Cruz

Related commands

CREATE ROUTE
ALTER ROUTE
sys.database_role_members