This function returns the logical file name for a given file identification (ID) number.
Transact-SQL Syntax Conventions
FILE_NAME ( file_id )
file_id
The file identification number whose file name FILE_NAME
will return. file_id has an int data type.
nvarchar(128)
file_ID corresponds to the file_id column in the sys.master_files catalog view or the sys.database_files catalog view.
This example returns the file names for file_ID 1
and file_ID
in the AdventureWorks2012 database.
Here is the result set.
File Name 1 File Name 2
------------------------- ------------------------
AdventureWorks2012_Data AdventureWorks2012_Log
(1 row(s) affected)
FILE_IDEX (Transact-SQL)
Metadata Functions (Transact-SQL)
sys.database_files (Transact-SQL)
sys.master_files (Transact-SQL)