Table of Contents

Class DataSpacesSchema.PartitionScheme

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

sys.partition_schemes (Transact-SQL)

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

Contains a row for each Data Space that is a partition scheme, with type = PS.


See sys.partition_schemes.

[Table(Schema = "sys", Name = "partition_schemes", IsView = true)]
public class DataSpacesSchema.PartitionScheme
Inheritance
DataSpacesSchema.PartitionScheme
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

FunctionID

ID of partition function used in the scheme.

[Column("function_id")]
[NotNull]
public int FunctionID { get; set; }

Property Value

int

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?

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?

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