Class PartitionFunctionSchema.PartitionFunction

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.partition_functions (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 partition function in SQL Server.

See sys.partition_functions.

[Table(Schema = "sys", Name = "partition_functions", IsView = true)]
public class PartitionFunctionSchema.PartitionFunction

Inheritance

object

PartitionFunctionSchema.PartitionFunction

Extension Methods

Map.DeepCopy<T>(T)

Properties

BoundaryValueOnRight

For range partitioning.

1 = Boundary value is included in the RIGHT range of the boundary.

0 = LEFT.

[Column("boundary_value_on_right")]
[NotNull]
public bool BoundaryValueOnRight { get; set; }

Property Value

bool

CreateDate

Date the function was created.

[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }

Property Value

DateTime

Fanout

Number of partitions created by the function.

[Column("fanout")]
[NotNull]
public int Fanout { get; set; }

Property Value

int

FunctionID

Partition function ID. Is unique within the database.

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

Property Value

int

IsSystem

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

1 = Object is used for full-text index fragments.

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

[Column("is_system")]
[NotNull]
public object IsSystem { get; set; }

Property Value

object

ModifyDate

Date the function was last modified using an ALTER statement.

[Column("modify_date")]
[NotNull]
public DateTime ModifyDate { get; set; }

Property Value

DateTime

Name

Name of the partition function. Is unique within the database.

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

Property Value

string

TypeColumn

Function type.

R = Range

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

Property Value

string

TypeDesc

Function type.

RANGE

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

Property Value

string