Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - Getting a List of All Databases on the Server
(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
SELECT name, database_id, create_date FROM sys.databases
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
(Continued on next topic...)
- What is a database?
- What is the simplest way to create a new database?
- How to set the current database?
- How to delete a database?
- Why I am getting this error when dropping a database?
- How to get a list all databases on the SQL server?
- Where is my database stored on the hard disk?
- How to create database with physical files specified?
- How to rename databases?
- Why I am getting this error when renaming a database?
- What are database states?
- How to set a database state to OFFLINE?
- How to move database physical files?
- How to set database to be READ_ONLY?
- How to set database to be SINGLE_USER?
- What are system databases?