Transact-SQL Reference
FILE_ID
Returns the file identification (ID) number for the given logical file name in the current database.
Syntax
FILE_ID ( 'file_name' )
Arguments
'file_name'
Is the name of the file for which to return the file ID. file_name is nchar(128).
Return Types
smallint
Remarks
file_name corresponds to the name column in sysfiles.
Examples
This example returns the file ID (1) for the master database.
USE master
SELECT FILE_ID('master')