Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Column Properties

The Column type exposes the following members.

  Name Description
Public property AnsiPaddingStatus Gets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED column option is active.
Public property Collation Gets or sets the default collation that is used by the column.
Public property Computed Gets the Boolean property value that specifies whether the column is the product of computed expression
Public property ComputedText Gets or sets the Transact-SQL expression that is used to generate the value of a computed column
Public property DataType Gets or sets the data type that is assigned to the column.
Public property Default Gets or sets the default bound to the column.
Public property DefaultConstraint Gets a default value for the column.
Public property DefaultSchema Gets or sets the default schema that is bound to the column.
Public property ExtendedProperties Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property for the Column object.
Public property ID Gets the column ID that uniquely identifies the column.
Public property Identity Gets or sets the Boolean property value that specifies whether the column is an identity column.
Public property IdentityIncrement Gets or sets the identity increment for an identity column.
Public property IdentitySeed Gets or sets the identity seed for an identity column.
Public property InPrimaryKey Gets the Boolean property value that specifies whether the column is included in the definition of a primary key or unique key constraint.
Public property IsColumnSet Gets or sets a Boolean value that specifies whether the column is a sparse column that is a member of a column set.
Public property IsDeterministic Gets or sets the Boolean property value that specifies whether the value of a computed column can change in subsequent invocations.
Public property IsFileStream Gets a boolean value that represents the FILESTREAM attribute of the column.
Public property IsForeignKey Gets the Boolean property value that specifies whether the column is a foreign key.
Public property IsFullTextIndexed Gets the Boolean property value that specifies whether the column participates in a full-text index.
Public property IsPersisted 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.
Public property IsPrecise Gets or sets the Boolean property value that specifies whether a computed column is a precise value.
Public property IsSparse Gets or sets the Boolean property value that specifies whether this is a sparse column. For more information about sparse columns, see Use Sparse Columns.
Public property Name Gets or sets a String value that specifies the name of the column. (Overrides NamedSmoObject.Name.)
Public property NotForReplication Gets the Boolean property value that specifies whether the column is participating in replication.
Public property Nullable Gets or sets the Boolean property value that specifies whether the column can accept null values.
Public property Parent Gets the SqlSmoObject object that is the parent of the Column object.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property RowGuidCol Gets or sets the Boolean property value that specifies whether the column is automatically updated with a unique GUID value.
Public property Rule Gets or sets the rule that is bound to the column.
Public property RuleSchema Gets or sets the rule schema that is bound to the column.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property StatisticalSemantics Gets or sets a value to indicate whether a column has been enabled for Semantic Extraction and Indexing.
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top
  Name Description
Explicit interface implemetation Private property ISfcSupportsDesignMode.IsDesignMode Gets a Boolean value that specifies whether the column supports design mode.
Top
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.