Applies To: SQL Server 2014, SQL Server 2016 Preview
Returns the names and attributes of filegroups associated with the current database.
Applies to: SQL Server (SQL Server 2008 through current version).
- [ @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)
Name of the filegroup.
Numeric filegroup identifier.
Number of files in the filegroup.
If name is specified, one row for each file in the filegroup is returned.
Logical name of the file in the filegroup.
Numeric file identifier.
Physical name of the file including the directory path.
File size in kilobytes.
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 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.