~/2007/09/09/list-all-databases-and-their-files-on-ms-sql.md

List all databases and their files on MS SQL

---
author: Tom Lasswell
date: 2007-09-09
read: 1 min
tags: [sql]
---

A quick way to check and see all databases for your MS SQL server is to run the following command using the Query Analyzer on the Master database:

sql

select name, filename from sysdatabases