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 √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW) √ SQL analytics endpoint in Microsoft Fabric √ Warehouse in Microsoft Fabric

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
Inherited Members
Extension Methods

Properties

DataSpaceID

data_space_id NOT NULL int

Data space ID number, unique within the database. 
[Column("data_space_id")]
[NotNull]
public int DataSpaceID { get; set; }

Property Value

int

FunctionID

function_id NOT NULL int

ID of partition function used in the scheme. 
[Column("function_id")]
[NotNull]
public int FunctionID { get; set; }

Property Value

int

IsDefault

is_default NULL bit

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

is_system NULL bit

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 NOT NULL sysname

Name of data space, unique within the database. 
[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

Type

type NOT NULL char(2)

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 Type { get; set; }

Property Value

string

TypeDesc

type_desc NULL nvarchar(60)

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