FILE_ID (T-SQL)

Returns the file identification number (file ID) 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')

See Also