Sql check roles

USE master  
GO  
SELECT DP1.name AS DatabaseRoleName,   
   isnull (DP2.name, 'No members') AS DatabaseUserName   
 FROM sys.database_role_members AS DRM  
 RIGHT OUTER JOIN sys.database_principals AS DP1  
   ON DRM.role_principal_id = DP1.principal_id  
 LEFT OUTER JOIN sys.database_principals AS DP2  
   ON DRM.member_principal_id = DP2.principal_id  
WHERE DP1.type = 'R'
ORDER BY DP1.name;

Similar codes

0 vote109 views1 answer
Data directory postgresql
SQL
0 vote132 views1 answer
Sql basic commands
SQL
6 votes107 views3 answers
How to delete table sqlite
SQL
0 vote121 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote111 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
3 votes103 views2 answers
Mysql create database
SQL
0 vote108 views1 answer
MySql get primary keys of table
SQL
0 vote116 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote136 views1 answer
Primary key start from number
SQL
10 votes117 views4 answers
Else if mysql
SQL