How to List all Contained Databases in a SQL Server Instance

Contained Databases feature is introduced in SQL Server 2012.

To list all Contained Databases in a SQL Server instance, run the following code:

SELECT name, containment, containment_desc
FROM sys.databases
WHERE containment <> 0;
GO

list_contained_databases

In Options tab od Database Properties window, you can see the Database Containment type:

contained_database_containment_type