sys.sp_helpfile

Description

Returns the physical names and attributes of files associated with the current database. Use this stored procedure to determine the names of files to attach to or detach from the server. The logical name of any file in the current database. isn’t specified, the attributes of all files in the current database are returned. Numeric identifier of the file.

Syntax

sp_helpfile [ [ @filename = ]
N
'filename'
]
[ ; ]