sp_helpfilegroup (Transact-SQL)

Returns the names and attributes of filegroups associated with the current database.

Syntax

sp_helpfilegroup [ [ @filegroupname = ] 'name' ]

[ @filegroupname = ] 'name'
Is the logical name of any filegroup in the current database. name is sysname, with a default of NULL. If name is not specified, all filegroups in the current database are listed and only the first result set shown in the Result Sets section is displayed.

0 (success) or 1 (failure)

Column name	Data type	Description
groupname	sysname	Name of the filegroup.
groupid	smallint	Numeric filegroup identifier.
filecount	int	Number of files in the filegroup.

If name is specified, one row for each file in the filegroup is returned.

Column name	Data type	Description
file_in_group	sysname	Logical name of the file in the filegroup.
fileid	smallint	Numeric file identifier.
filename	nchar(260)	Physical name of the file including the directory path.
size	nvarchar(15)	File size in kilobytes.
maxsize	nvarchar(15)	Maximum size of the file. This is the maximum size to which the file can grow. A value of UNLIMITED in this field indicates that the file grows until the disk is full.
growth	nvarchar(15)	Growth increment of the file. This indicates the amount of space added to the file every time new space is required. 0 = File is a fixed size and will not grow.

Requires membership in the public role.

The following example returns information about the filegroups in the AdventureWorks2012 sample database.

USE AdventureWorks2012;
GO
EXEC sp_helpfilegroup;
GO

The following example returns information for all files in the PRIMARY filegroup in the AdventureWorks2012 sample database.

USE AdventureWorks2012;
GO
EXEC sp_helpfilegroup 'PRIMARY';
GO