How to get the list of databases in the sql server

There are various system views and system stored procedure to see the list of databases on the server.

Which is very useful to see the created data, size, path of the database, created owner, etc..,



1) SP_DATABASES

2) SELECT * FROM sys.databases

3) SELECT * FROM sys.master_files  WHERE TYPE=0

The above statement can be executed in the sql server query window to fetch the attributes of the database.
Ebook Download
View all
Learn
View all