SQL Server: sp_helpdb

Show names, sizes, owners, db ids, creation date, status and compatibility levels for each database.

exec sp_helpdb

With the parameter @dbname, sp_helpdb returns the same information for the given database and adds an additional recordset that shows the file allocation for the database.

exec sp_helpdb @dbname = 'tq84_db'