Column.IsDeterministic Property

 

Gets or sets the Boolean property value that specifies whether the value of a computed column can change in subsequent invocations.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase)]
public bool IsDeterministic { get; }

Property Value

Type: System.Boolean

A Boolean value that specifies the whether a computed column can change between invocations.

If the computed column contained a value that was calculated from the current date, for example, the column would not be deterministic. The value of the column would change as the date changes and therefore would be different for subsequent invocations.

Return to top
Show: