databases-and-files-catalog-views-transact-sql.md

---

title: "Databases and Files Catalog Views (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "01/18/2016" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology:

• "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" dev_langs:
• "TSQL" helpviewer_keywords:
• "file catalog views [SQL Server]"
• "catalog views [SQL Server], databases"
• "database catalog views [SQL Server]"
• "catalog views [SQL Server], files" ms.assetid: 60a05111-c542-45b5-a0cb-433ddcf6286a caps.latest.revision: 34 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"

---

Databases and Files Catalog Views (Transact-SQL)

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md]

This section contains the following catalog views.

sys.backup_devices (Transact-SQL)	sys.database_recovery_status (Transact-SQL)
sys.database_connection_stats (Azure SQL Database)	sys.database_scoped_configurations (Transact-SQL)
sys.databases (Transact-SQL)	sys.database_usage (Azure SQL Database)
sys.database_files (Transact-SQL)	sys.master_files (Transact-SQL)
sys.database_mirroring (Transact-SQL)

See Also

Catalog Views (Transact-SQL)
System Views (Transact-SQL)