Share via

TemporalRetentionPeriodUnit Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:
Microsoft.SqlServer.TransactSql.ScriptDom.dll
Package:
Microsoft.SqlServer.DacFx.x64 v140.3881.1
Package:
Microsoft.SqlServer.DacFx v150.5282.3
Package:
Microsoft.SqlServer.DacFx v160.6161.0
Package:
Microsoft.Data.Tools.Msbuild v10.0.61804.210
Package:
Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

Possible values for units in HISTORY_RETENTION_PERIOD clause.

C# 
public enum TemporalRetentionPeriodUnit
Inheritance
Enum
TemporalRetentionPeriodUnit

Fields

Name Value Description
Day 0

Retention period is expressed in days.
Days 1

Retention period is expressed in days.
Week 2

Retention period is expressed in weeks.
Weeks 3

Retention period is expressed in weeks.
Month 4

Retention period is expressed in months.
Months 5

Retention period is expressed in months.
Year 6

Retention period is expressed in years.
Years 7

Retention period is expressed in years.

Applies to

Product Versions
Microsoft.SQLServer.DacFx 140.3881.1, 150.18208.0, 160.2004021.0, 161.6374.0, 161