Table of Contents

Class DataSpacesSchema.FileGroup

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.filegroups (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)

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


See sys.filegroups.

[Table(Schema = "sys", Name = "filegroups", IsView = true)]
public class DataSpacesSchema.FileGroup
Inheritance
DataSpacesSchema.FileGroup
Extension Methods

Properties

DataSpaceID

Data space ID number, unique within the database.

[Column("data_space_id")]
[NotNull]
public int DataSpaceID { get; set; }

Property Value

int

FilegroupGuid

GUID for the filegroup.

NULL = PRIMARY filegroup

[Column("filegroup_guid")]
[Nullable]
public Guid? FilegroupGuid { get; set; }

Property Value

Guid?

IsAutogrowAllFiles

Applies to: √ SQL Server 2016 (13.x) and later.

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.

[Column("is_autogrow_all_files")]
[Nullable]
public bool? IsAutogrowAllFiles { get; set; }

Property Value

bool?

IsDefault

1 = This is the default data space. The default data space is used when a filegroup or partition scheme is not specified in a CREATE TABLE or CREATE INDEX statement.

0 = This is not the default data space.

[Column("is_default")]
[Nullable]
public bool? IsDefault { get; set; }

Property Value

bool?

IsReadOnly

1 = Filegroup is read-only.

0 = Filegroup is read/write.

[Column("is_read_only")]
[Nullable]
public bool? IsReadOnly { get; set; }

Property Value

bool?

IsSystem

Applies to: SQL Server 2012 (11.x) and later.

1 = Data space is used for full-text index fragments.

0 = Data space is not used for full-text index fragments.

[Column("is_system")]
[Nullable]
public bool? IsSystem { get; set; }

Property Value

bool?

LogFileGroupID

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. In SQL Server, the value is NULL.

[Column("log_filegroup_id")]
[Nullable]
public int? LogFileGroupID { get; set; }

Property Value

int?

Name

Name of data space, unique within the database.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

TypeColumn

Data space type:

FG = Filegroup

FD = FILESTREAM data filegroup

FX = Memory-optimized tables filegroup

Applies to: SQL Server 2014 (12.x) and later.

PS = Partition scheme

[Column("type")]
[NotNull]
public string TypeColumn { get; set; }

Property Value

string

TypeDesc

Description of data space type:

FILESTREAM_DATA_FILEGROUP

MEMORY_OPTIMIZED_DATA_FILEGROUP

Applies to: SQL Server 2014 (12.x) and later.

PARTITION_SCHEME

ROWS_FILEGROUP

[Column("type_desc")]
[Nullable]
public string? TypeDesc { get; set; }

Property Value

string