Transact-SQL Reference
FILEGROUP_NAME
Returns the filegroup name for the given filegroup identification (ID) number.
Syntax
FILEGROUP_NAME ( filegroup_id )
Arguments
filegroup_id
Is the filegroup ID number for which to return the filegroup name. filegroup_id is smallint.
Return Types
nvarchar(128)
Remarks
filegroup_id corresponds to the groupid column in sysfilegroups.
Examples
This example returns the filegroup name for the filegroup ID 1 (the default).
USE master
SELECT FILEGROUP_NAME(1)