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.

public enum TemporalRetentionPeriodUnit
type TemporalRetentionPeriodUnit = 
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