SQL Server/T-SQL Tutorial/System Functions/sp HelpRole
A statement that lists the roles for the current database
<source lang="sql">
EXEC sp_HelpRole</source>
Display database role information:
<source lang="sql">
The syntax for sp_HelpRole sp_HelpRole [[@rolename = ] "database_role_name"]</source>