MSSQL Databases
Check
Check
To show key information about each database...
SELECT sd.database_id,
sd.name,
sd.create_date,
sd.compatibility_level,
sd.state_desc,
sd.recovery_model_desc,
sd.is_encrypted,
smf.size*8/1024/1024 as sizeGB
FROM sys.databases sd,
sys.master_files smf
WHERE sd.database_id = smf.database_id
AND smf.type=0
AND sd.database_id > 4
ORDER BY database_id
Try also..
EXEC sp_databases
EXEC sp_helpdb
Bibliography
Bibliography
https://www.brentozar.com/archive/2020/09/unindexed-foreign-keys-can-make-performance-worse/https://stackoverflow.com/questions/2902629/how-can-i-get-all-the-database-names-in-a-sql-server-instance-using-tsql/2902636https://dba.stackexchange.com/questions/29543/query-to-report-disk-space-allocation-and-used-space