title: "sys.filegroups (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "05/24/2016" ms.prod: "sql" ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.service: "" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "sys.filegroups_TSQL"
- "filegroups"
- "sys.filegroups"
- "filegroups_TSQL" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.filegroups catalog view" ms.assetid: 9e851f72-1f8e-4515-a25d-152ebc12ed56 caps.latest.revision: 54 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2008-all-md]
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 | [!INCLUDEssInternalOnly] In [!INCLUDEssNoVersion], the value is NULL. |
| is_read_only | bit | 1 = Filegroup is read-only. 0 = Filegroup is read/write. |
| is_autogrow_all_files | bit | Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssSQL15] through current version). 1 = When a file in the filegroup meets the autogrow threshold, all files in the filegroup grow. 0 = When a file in the filegroup meets the autogrow threshold, only that file grows. This is the default. |
Requires membership in the public role. For more information, see Metadata Visibility Configuration.