how to get list of users in sql server database code example

Example: sql show all users

#For the SQL Server Owner, you should be able to use:
select suser_sname(owner_sid) as 'Owner', state_desc, *
from sys.databases

#For a list of SQL Users:
select * from master.sys.server_principals