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.