How to get the list of databases in the sql server

This blog explains about how to list the databases in the sql server in the query window.

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.