Class PartitionFunctionSchema.PartitionParameter

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.partition_parameters (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 parameter of a partition function.

See sys.partition_parameters.

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

Inheritance

object

PartitionFunctionSchema.PartitionParameter

Extension Methods

Map.DeepCopy<T>(T)

Properties

CollationName

Name of the collation of the parameter if character-based; otherwise, NULL.

[Column("collation_name")]
[Nullable]
public string? CollationName { get; set; }

Property Value

string

FunctionID

ID of the partition function to which this parameter belongs.

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

Property Value

int

MaxLength

Maximum length of the parameter in bytes.

[Column("max_length")]
[NotNull]
public short MaxLength { get; set; }

Property Value

short

ParameterID

ID of the parameter. Is unique within the partition function, beginning with 1.

[Column("parameter_id")]
[NotNull]
public int ParameterID { get; set; }

Property Value

int

Precision

Precision of the parameter if numeric-based; otherwise, 0.

[Column("precision")]
[NotNull]
public byte Precision { get; set; }

Property Value

byte

Scale

Scale of the parameter if numeric-based; otherwise, 0.

[Column("scale")]
[NotNull]
public byte Scale { get; set; }

Property Value

byte

SystemTypeID

ID of the system type of the parameter. Corresponds to the system_type_id column of the sys.types catalog view.

[Column("system_type_id")]
[NotNull]
public byte SystemTypeID { get; set; }

Property Value

byte

UserTypeID

ID of the type. Is unique within the database. For system data types, user_type_id = system_type_id.

[Column("user_type_id")]
[NotNull]
public int UserTypeID { get; set; }

Property Value

int