sys.sp_helpfilegroup

Description

Returns the names and attributes of filegroups associated with the current database. The logical name of any filegroup in the current database. isn’t specified, all filegroups in the current database are listed and only the first result set shown in the Result Sets section is displayed.

Syntax

sp_helpfilegroup [ [ @filegroupname = ]
N
'filegroupname'
]
[ ; ]