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

title	Databases and Files Catalog Views (Transact-SQL)
description	Databases and Files Catalog Views (Transact-SQL)
author	rwestMSFT
ms.author	randolphwest
ms.date	01/18/2016
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
ms.custom	ignite-2025
helpviewer_keywords	file catalog views [SQL Server] catalog views [SQL Server], databases database catalog views [SQL Server] catalog views [SQL Server], files
dev_langs	TSQL
monikerRange	=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

Databases and Files Catalog Views (Transact-SQL)

[!INCLUDE sqlserver2016-asdb-asdbmi-fabricsqldb]

This section contains the following catalog views.

:::row::: :::column::: sys.backup_devices (Transact-SQL)

    [sys.database_connection_stats (Azure SQL Database)](../../relational-databases/system-catalog-views/sys-database-connection-stats-azure-sql-database.md)
    
    [sys.databases (Transact-SQL)](../../relational-databases/system-catalog-views/sys-databases-transact-sql.md)
    
    [sys.database_files (Transact-SQL)](../../relational-databases/system-catalog-views/sys-database-files-transact-sql.md)
    
    [sys.database_mirroring (Transact-SQL)](../../relational-databases/system-catalog-views/sys-database-mirroring-transact-sql.md)
:::column-end:::
:::column:::
    [sys.database_recovery_status (Transact-SQL)](../../relational-databases/system-catalog-views/sys-database-recovery-status-transact-sql.md)
    
    [sys.database_scoped_configurations (Transact-SQL)](../../relational-databases/system-catalog-views/sys-database-scoped-configurations-transact-sql.md)
    
    [sys.master_files (Transact-SQL)](../../relational-databases/system-catalog-views/sys-master-files-transact-sql.md)
:::column-end:::

:::row-end:::

See Also

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