1 out of 1 rated this helpful - Rate this topic

sys.filegroups (Transact-SQL)

SQL Server 2008

Contains a row for each data space that is a filegroup.

Column name	Data type	Description
<inherited columns>	--	For a list of columns that this view inherits, see sys.data_spaces (Transact-SQL).
filegroup_guid	uniqueidentifier	GUID for the filegroup. NULL = PRIMARY filegroup
log_filegroup_id	int	Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. In SQL Server, the value is NULL.
is_read_only	bit	1 = Filegroup is read-only. 0 = Filegroup is read/write.

Requires membership in the public role. For more information, see Metadata Visibility Configuration.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions