Skip to content

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

Latest commit

 

History

History
52 lines (41 loc) · 2.55 KB

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

File metadata and controls

52 lines (41 loc) · 2.55 KB
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.prod sql
ms.prod_service database-engine, sql-database
ms.technology system-objects
ms.topic reference
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
ms.assetid 60a05111-c542-45b5-a0cb-433ddcf6286a
monikerRange =azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

Databases and Files Catalog Views (Transact-SQL)

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

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.database_usage (Azure SQL Database)](../../relational-databases/system-catalog-views/sys-database-usage-azure-sql-database.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)