To know about your database details

select * from sysfiles

OR

select * from sys.databases where name ='DatabaseName'