Column.IsPersisted Property

Artikkeli
12/03/2008

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
Public Property IsPersisted As Boolean

public bool IsPersisted { get; set; }

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

/** @property */
public boolean get_IsPersisted ()

/** @property */
public void set_IsPersisted (boolean value)

public function get IsPersisted () : boolean

public function set IsPersisted (value : boolean)

Property Value

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.

Remarks

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Create, Alter, and Remove a Table in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms