sys.computed_columns (Transact-SQL)

Contains a row for each column found in sys.columns that is a computed-column.

Column name

Data type

Description

<Inherited columns>

 

For a list of columns that this view inherits, see sys.columns (Transact-SQL).

definition

nvarchar(max)

SQL text that defines this computed-column.

SQL Server 2008 and SQL Server 2005 differ from SQL Server 2000 in the way they decode and store SQL expressions in the catalog metadata. The semantics of the decoded expression are equivalent to the original text; however, there are no syntactic guarantees. For example, white spaces are removed from the decoded expression.

uses_database_collation

bit

1 = The column definition depends on the default collation of the database for correct evaluation; otherwise, 0. Such a dependency prevents changing the database default collation.

is_persisted

bit

Computed column is persisted.

is_computed

bit

Computed column is computed. Always 1.

is_sparse

bit

1 = Column is a sparse column. For more information, see Using Sparse Columns.

is_column_set

bit

1 = Column is a column set. For more information, see Using Column Sets.

Permissions

In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.