• Article

Column.IsPersisted Property

Gets the Boolean property value that specifies whether the computed value of the Column object is saved with the data, thus avoiding a computation each time the column is accessed.

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

Syntax

'Declaration
<SfcPropertyAttribute> _
Public Property IsPersisted As Boolean
    Get
    Set
'Usage
Dim instance As Column
Dim value As Boolean

value = instance.IsPersisted

instance.IsPersisted = value

[SfcPropertyAttribute]
public bool IsPersisted { get; set; }

[SfcPropertyAttribute]
public:
property bool IsPersisted {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute>]
member IsPersisted : bool with get, set

function get IsPersisted () : boolean
function set IsPersisted (value : boolean)

Property Value

Type: System.Boolean
A Boolean property value that specifies whether the computed value of the Column object is saved with the data.
If True, the computed value of the Column object is saved with the data.
If False (default), the computed value of the Column object is computed every time the column data is requested.
The IsPersisted property can only be set to True for computed columns. Otherwise, it will cause an error.