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.

See Also

Reference

Column Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Indexes on Computed Columns

CREATE TABLE (Transact-SQL)