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)

See Also