Table of Contents

Class ObjectSchema.Period

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

sys.periods (Transact-SQL)

Applies to: √ SQL Server 2016 (13.x) and later

Returns a row for each table for which periods have been defined.


See sys.periods.

[Table(Schema = "sys", Name = "periods", IsView = true)]
public class ObjectSchema.Period
Inheritance
ObjectSchema.Period
Extension Methods

Properties

EndColumnID

The id of the column that defines the upper period boundary

[Column("end_column_id")]
[NotNull]
public int EndColumnID { get; set; }

Property Value

int

Name

Name of the period

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

Property Value

string

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

The id of the table containing the period_type column

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

PeriodType

The numeric value representing the type of period:

1 = system-time period

[Column("period_type")]
[Nullable]
public byte? PeriodType { get; set; }

Property Value

byte?

PeriodTypeDesc

The text description of the type of column:

SYSTEM_TIME_PERIOD

[Column("period_type_desc")]
[Nullable]
public string? PeriodTypeDesc { get; set; }

Property Value

string

StartColumnID

The id of the column that defines the lower period boundary

[Column("start_column_id")]
[NotNull]
public int StartColumnID { get; set; }

Property Value

int