Skip to content

Latest commit

 

History

History
48 lines (38 loc) · 2.25 KB

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

File metadata and controls

48 lines (38 loc) · 2.25 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords dev_langs monikerRange
Databases and Files Catalog Views (Transact-SQL)
Databases and Files Catalog Views (Transact-SQL)
rwestMSFT
randolphwest
01/18/2016
sql
system-objects
reference
file catalog views [SQL Server]
catalog views [SQL Server], databases
database catalog views [SQL Server]
catalog views [SQL Server], files
TSQL
=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.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)