Transact-SQL Reference
FILE_NAME
Returns the logical file name for the given file identification (ID) number.
Syntax
FILE_NAME ( file_id )
Arguments
file_id
Is the file identification number for which to return the file name. file_id is smallint.
Return Types
nvarchar(128)
Remarks
file_ID corresponds to the fileid column in sysfiles.
Examples
This example returns the file name for a file_ID of 1 (the master database file).
USE master
SELECT FILE_NAME(1)