FILEGROUP_NAME (T-SQL)

Returns the filegroup name for the given filegroup identification number (ID).

Syntax

FILEGROUP_NAME(filegroup_id)

Arguments

filegroup_id

Is the filegroup identification number (ID) 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