Did you try searching? I'd have thought that a quick Google search would've answered this question for you far quicker than waiting on a forum.

https://msdn.microsoft.com/en-us/library/ms174397.aspx

SELECT file_id,

name,

physical_name,

is_read_only

FROM sys.database_files;