DBCC CHECKPRIMARYFILE command reads the metadata from the primary database data file (mdf) file and returns very useful information such as Database Name  Logical Names  Physical File Names etc without attaching the database to the SQL Server