IsComputed Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The IsComputed property reports whether the Column object references a computed Microsoft SQL Server column.

Syntax

object.IsComputed [=value]

Parts

• object
  An expression that evaluates to an object in the Applies To list

• value
  TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write before column creation. Read-only if referencing an existing column.

Prototype (C/C++)

HRESULT GetIsComputed(LPBOOL pRetVal);
HRESULT SetIsComputed(BOOL NewValue);

Remarks

If TRUE, the referenced column is, or will be created as, a computed column. When creating a computed column, set IsComputed to TRUE and set the ComputedText property to define the column's computed expression.

If FALSE, the Column object references a column that can contain literal values.

Applies To:

Column Object