Find All the Database names of the server

Question

Hi, How I can find all the database names of any server?

Answer 1

Hi @M Jugnu ,

Please refer to:

    SELECT * FROM sysdatabases  

SELECT name FROM sysdatabases  

If you have any question, please feel free to let me know.
If the response is helpful, please click "Accept Answer" and upvote it.

Regards
Echo

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October https://learn.microsoft.com/en-us/answers/questions/142427/users-always-get-connection-timeout-problem-when-u.html

Answer 2

sys.sysdatabase is an old system view and deprecated, better don't use that one
See https://learn.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-sysdatabases-transact-sql?view=sql-server-ver15

Better use sys.databases
See https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-databases-transact-sql?view=sql-server-ver15