Contained databases are one of the favorite features introduced in SQL Server 2012. Contained databases are isolated / independent databases from the other databases and from the instance it is hosted on.
Today, we will go through a very simple script related to contained databases and in this script we need to find the list of all contained databases only. Given below is the script.
Select name as [Database Name], containment ,containment_desc from sys.databases Where [containment] =1 --OUTPUT
SQL Server Portal 
Leave a Reply