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

適用範圍:Applies to: 是SQL ServerSQL Server (所有支援的版本) yesSQL ServerSQL Server (all supported versions) 是Azure SQL DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure 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 DatabaseAzure SQL DatabaseYesAzure SQL DatabaseAzure 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> -- 如需此 view 所繼承之資料行的清單,請參閱 sys.data_spaces (transact-sql)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 適用於SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x)目前版本)。Applies to: SQL ServerSQL Server (SQL Server 2016 (13.x)SQL Server 2016 (13.x) through current version).

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

需要 public 角色的成員資格。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)