SQL Server/T-SQL Tutorial/System Functions/sp HelpRole

A statement that lists the roles for the current database

EXEC sp_HelpRole

Display database role information:

The syntax for sp_HelpRole
sp_HelpRole [[@rolename = ] "database_role_name"]