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.