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)

See Also