Collections:
Getting a List of All Databases on the Server in SQL Server
How to get a list all databases on the SQL server in SQL Server?
✍: FYIcenter.com
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.
⇒ Location of Database Files in SQL Server
⇐ Database in Use When Dropping a Database in SQL Server
2016-11-24, 1395🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...