Dela via


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)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property IsDeterministic As Boolean
    Get
'Usage
Dim instance As Column
Dim value As Boolean

value = instance.IsDeterministic
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool IsDeterministic { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool IsDeterministic {
    bool get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member IsDeterministic : bool
function get IsDeterministic () : boolean

Property Value

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

Remarks

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.