DROP ROLE

Drop a role.

Syntax
      DROP ROLE role

Key
   role     The role to drop. 

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

Example

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
Equivalent Oracle command: DROP ROLE