SQL Server: sp_droprole

sp_droprole drops a database role from the current database.