Contained Databases feature is introduced in SQL Server 2012.
User authentication for contained users (users with passwords) is performed by the contained database.
To list all contained users that are authenticated by the contained database, use the following query:
SELECT name, type_desc, authentication_type, authentication_type_desc
FROM sys.database_principals WHERE authentication_type = 2