Share via

  • Article

Properties, clsColumn

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

An object of ClassType clsColumn supports the following properties.

Property

Description

Access

AreKeysUnique

Indicates whether key columns defined in the Columns collection uniquely identify members in the case table.

R/W

ClassType

Returns an enumeration constant that identifies the specific object type.

R

ContentType

Describes the content type of a column's data.

R/W*

DataType

The data type of the column.

R/W*

Description

The description of the column.

R/W

Distribution

Identifies the statistical distribution of a column's data.

R/W

Filter

Filters the rows used in the nested table.

R/W*

FromClause

Specifies the FROM clause of the SQL query that returns a nested table for a column.

R/W*

IsDisabled

Specifies whether a column is disabled for training purposes.

R/W

IsInput

Indicates whether a column can accept input values for training a mining model object. For more information, see IsPredictable.

R/W

IsKey

Indicates whether or not the column is a key column in a case table or a nested table.

R/W*

IsParentKey

Indicates whether the column is a foreign key that relates to the case table.

R or R/W*

IsPredictable

Indicates whether this column can be predicted based on other input columns. For more information, see IsInput.

R/W

JoinClause

Specifies the JOIN clause of the SQL query that returns a nested table for a column.

R/W*

ModelingFlags

Specifies modeling options for a column.

R/W

Name

The name of the column.

R/W

Num

The ordinal position of the column.

R/W

Parent

The parent mining model or column object.

R

RelatedColumn

The column to which a column is related.

R/W*

SourceColumn

The name of the column's source column in a relational table.

R/W*

SourceOlapObject

The name of a column's source Decision Support Objects (DSO) object.

R/W

SpecialFlag

Identifies the statistical nature of a column's data.

R/W

SubClassType

Returns an enumeration constant that identifies the subclass type.

R

* This property applies only to columns of SubClassType sbclsRegular. This property applies only to columns belonging to ClassType clsMiningModel objects of SubClassType sbclsRegular. This property applies only to columns belonging to ClassType clsMiningModel objects of SubClassType sbclsOlap.