Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Getting a List of All Databases on the Server

By: FYIcenter.com

(Continued from previous topic...)

How to get a list all databases on the SQL server?

If you don't remember database names you have created, you can get a list of all databases on the server by query the "sys.databases" view as shown in this tutorial example:

CREATE DATABASE FyiCenterData
GO

SELECT name, database_id, create_date FROM sys.databases
GO
name     database_id   create_date
master             1   2003-04-08 09:13:36.390
tempdb             2   2007-05-19 13:42:42.200
model              3   2003-04-08 09:13:36.390
msdb               4   2005-10-14 01:54:05.240
FyiCenterData      5   2007-05-19 20:04:39.310

As you can see, the newly created database is listed at the end of query result.

(Continued on next topic...)

1. What is a database?
2. What is the simplest way to create a new database?
3. How to set the current database?
4. How to delete a database?
5. Why I am getting this error when dropping a database?
6. How to get a list all databases on the SQL server?
7. Where is my database stored on the hard disk?
8. How to create database with physical files specified?
9. How to rename databases?
10. Why I am getting this error when renaming a database?
11. What are database states?
12. How to set a database state to OFFLINE?
13. How to move database physical files?
14. How to set database to be READ_ONLY?
15. How to set database to be SINGLE_USER?
16. What are system databases?