MSSQL%20Interview%20Questions%20and%20Answers
Question: How to get a list all databases on the SQL server?Answer: 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 withoutbookdb 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 withoutbookdb 5 2007-05-19 20:04:39.310 As you can see, the newly created database is listed at the end of query result. |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is Microsoft SQL Server?
- What is the simplest way to create a new database in MS SQL Server?
- How to delete a database in MS SQL Server?
- How to download and install Microsoft .NET Framework Version 2.0?
- How To Get a List of Columns using the "sp_help" Stored Procedure in MS SQL Server?