sp_helpfilegroup (Transact-SQL)
Returns the names and attributes of filegroups associated with the current database.
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. |
A. Returning all filegroups in a database
The following example returns information about the filegroups in the AdventureWorks sample database.
USE AdventureWorks; GO EXEC sp_helpfilegroup; GO
B. Returning all files in a filegroup
The following example returns information for all files in the PRIMARY filegroup in the AdventureWorks sample database.
USE AdventureWorks; GO EXEC sp_helpfilegroup 'PRIMARY'; GO
