Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

FILE_NAME (Transact-SQL)

Returns the logical file name for the given file identification (ID) number.

Topic link iconTransact-SQL Syntax Conventions

FILE_NAME (file_id)


Is the file identification number for which to return the file name. file_id is int.


file_ID corresponds to the file_id column in the sys.master_files or sys.database_files catalog views.

The following example returns the file names for file_ID 1 and file_ID in the AdventureWorks database.

USE AdventureWorks;
SELECT FILE_NAME(1) AS 'File Name 1', FILE_NAME(2) AS 'File Name 2';

Here is the result set.

File Name 1           File Name 2
----------------      ------------------------ 
AdventureWorks_Data   AdventureWorks_Log 
(1 row(s) affected)
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft