FILEGROUP_NAME (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2008) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

This function returns the filegroup name for the specified filegroup identification (ID) number.

Topic link icon Transact-SQL Syntax Conventions

Syntax

FILEGROUP_NAME ( filegroup_id )   

Arguments

filegroup_id

The filegroup ID number whose filegroup name FILEGROUP_NAME will return. filegroup_id has a smallint data type.

Return Types

nvarchar(128)

Remarks

filegroup_id corresponds to the data_space_id column of the sys.filegroups catalog view.

Examples

This example returns the filegroup name for filegroup ID 1 in the AdventureWorks2012 database.

SELECT FILEGROUP_NAME(1) AS [Filegroup Name];  
GO  

Here is the result set.

Filegroup Name   
-----------------------  
PRIMARY  

(1 row(s) affected)  

See Also

Metadata Functions (Transact-SQL)
SELECT (Transact-SQL)
sys.filegroups (Transact-SQL)