Table of Contents

Class CompatibilitySchema.FileGroup

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

sys.sysfilegroups (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

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


This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping System Tables to System Views (Transact-SQL). This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.


See sys.sysfilegroups.

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

Properties

AllocPolicy

Reserved

[Column("allocpolicy")]
[Nullable]
public short? AllocPolicy { get; set; }

Property Value

short?

GroupID

Group identification number unique for each database.

[Column("groupid")]
[Nullable]
public short? GroupID { get; set; }

Property Value

short?

GroupName

Name of the file group.

[Column("groupname")]
[NotNull]
public string GroupName { get; set; }

Property Value

string

Status

0x8 = Read-only

0x10 = Default

[Column("status")]
[Nullable]
public int? Status { get; set; }

Property Value

int?