Get List of User Databases from SQL Server - SQL Server Tutorial

In this short quick post we will learn how we can get the list of all user Database from SQL Server. SQL Server provided different system views those can be used to get information about objects present in SQL Server. To get list of all databases we can use sys.databases view that provides name of databases with other properties such as recovery model, state_desc,compatibility level etc. link to post for scripts used in this video : http://sqlage.blogspot.com/2015/02/get-list-of-all-databases-from-sql.html