sys.filegroups (Transact-SQL)sys.filegroups (Transact-SQL)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) 是Azure SQL 数据库Azure SQL DatabaseYesAzure SQL 数据库Azure SQL Database 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics 是并行数据仓库Parallel Data Warehouseyes并行数据仓库Parallel Data Warehouse

每个作为文件组的数据空间都在表中对应一行。Contains a row for each data space that is a filegroup.

列名称Column name 数据类型Data type 说明Description
<inherited columns> -- 有关此视图所继承的列的列表,请参阅 (transact-sql)sys.data_spaces For a list of columns that this view inherits, see sys.data_spaces (Transact-SQL).
filegroup_guidfilegroup_guid uniqueidentifieruniqueidentifier 文件组的 GUID。GUID for the filegroup.

NULL = PRIMARY 文件组NULL = PRIMARY filegroup
log_filegroup_idlog_filegroup_id intint 标识为仅供参考。Identified for informational purposes only. 不支持。Not supported. 不保证以后的兼容性。Future compatibility is not guaranteed.SQL ServerSQL Server 中,其值为 NULL。In SQL ServerSQL Server, the value is NULL.
is_read_onlyis_read_only bitbit 1 = 文件组为只读文件组。1 = Filegroup is read-only.

0 = 文件组为可读/写的文件组。0 = Filegroup is read/write.
is_autogrow_all_filesis_autogrow_all_files bitbit 适用于:Applies to: 是SQL Server 2016 (13.x)SQL Server 2016 (13.x)yesSQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更高版本适用于:Applies to: 是SQL Server 2016 (13.x)SQL Server 2016 (13.x)yesSQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.适用于:Applies to: 是SQL Server 2016 (13.x)SQL Server 2016 (13.x)yesSQL Server 2016 (13.x)SQL Server 2016 (13.x) 及更高版本适用于:Applies to: 是SQL Server 2016 (13.x)SQL Server 2016 (13.x)yesSQL Server 2016 (13.x)SQL Server 2016 (13.x) and later.

1 = 当文件组中的某个文件达到自动增长阈值时,文件组中的所有文件都会增长。1 = When a file in the filegroup meets the autogrow threshold, all files in the filegroup grow.

0 = 当文件组中的某个文件达到自动增长阈值时,只有该文件会增长。0 = When a file in the filegroup meets the autogrow threshold, only that file grows. 这是默认值。This is the default.

权限Permissions

要求 公共 角色具有成员身份。Requires membership in the public role. 有关详细信息,请参阅 Metadata Visibility ConfigurationFor more information, see Metadata Visibility Configuration.

另请参阅See Also

目录视图 (Transact-SQL) Catalog Views (Transact-SQL)
数据空间 (Transact-sql)Data Spaces (Transact-SQL)