Databases and Files Catalog Views (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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)