Use AdventureWorks2014;

Select OBJECT_SCHEMA_NAME(PA.object_id) + N'.' + OBJECT_NAME(PA.object_id) As ObjectName,
    DF.name As FileName,
    PA.allocation_unit_type_desc As TypeData,
    PA.allocated_page_file_id As FileID,
    PA.allocated_page_page_id As PageID
From sys.dm_db_database_page_allocations(db_id(), null, 1, null, 'limited') PA
Inner Join sys.database_files DF On DF.file_id = PA.allocated_page_file_id
Order By PA.object_id;