FILEGROUP_ID (Transact-SQL)
Applies to: SQL Server Azure SQL Managed Instance
This function returns the filegroup identification (ID) number for a specified filegroup name.
Transact-SQL syntax conventions
FILEGROUP_ID ( 'filegroup_name' )
filegroup_name
An expression of type sysname, representing the filegroup name whose filegroup ID FILEGROUP_ID
will return.
int
filegroup_name corresponds to the name column in the sys.filegroups catalog view.
This example returns the filegroup ID for the filegroup named PRIMARY
in the AdventureWorks2022 database.
SELECT FILEGROUP_ID('PRIMARY') AS [Filegroup ID];
GO
Here's the result set.
Filegroup ID
------------
1
(1 row(s) affected)
FILEGROUP_NAME (Transact-SQL)
Metadata Functions (Transact-SQL)
sys.filegroups (Transact-SQL)