sys-sysfilegroups-transact-sql.md

title	sys.sysfilegroups (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sysfilegroups_TSQL sys.sysfilegroups sysfilegroups sys.sysfilegroups_TSQL
dev_langs	TSQL
helpviewer_keywords	sysfilegroups system table sys.sysfilegroups compatibility view
ms.assetid	e567fa07-31cd-43cc-b8c7-ba6108baca80
caps.latest.revision	30
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sys.sysfilegroups (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Contains one row for each file group in a database. There is at least one entry in this table that is for the primary file group.

Important

[!INCLUDEssnoteCompView]

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

Column name	Data type	Description
groupid	smallint	Group identification number unique for each database.
allocpolicy	smallint	Reserved
status	int	0x8 = Read-only 0x10 = Default
groupname	sysname	Name of the file group.

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)