MS SQL Server Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
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 GlobalGuideLineDatabase
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
GlobalGuideLineDatabase 5 2007-05-19 20:04:39.310
As you can see, the newly created database is listed at the end of query result.
CREATE DATABASE GlobalGuideLineDatabase
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
GlobalGuideLineDatabase 5 2007-05-19 20:04:39.310
As you can see, the newly created database is listed at the end of query result.
Download MS SQL Server Interview Questions And Answers
PDF
Previous Question | Next Question |
Why I am getting this error when dropping a database in MS SQL Server? | Where is my database stored on the hard disk in MS SQL Server? |