Viewing Roles
When creating and using a database, you may need to find information about a Microsoft® SQL Server™ database role or a fixed server role. For example, you may need to see which roles exist in the current database, or list the fixed server roles.
To view the roles defined in the current database
Transact-SQL