FILE_ID

Transact-SQL Reference

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')

See Also

Control-of-Flow Language

DELETE

INSERT

Metadata Functions

SELECT

UPDATE

WHERE