Column Properties

Column Properties

 

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyAnsiPaddingStatus

Gets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED column option is active.

System_CAPS_pubpropertyCollation

Gets or sets the default collation that is used by the column.

System_CAPS_pubpropertyColumnEncryptionKeyID

System_CAPS_pubpropertyColumnEncryptionKeyName

System_CAPS_pubpropertyComputed

Gets the Boolean property value that specifies whether the column is the product of computed expression

System_CAPS_pubpropertyComputedText

Gets or sets the Transact-SQL expression that is used to generate the value of a computed column

System_CAPS_pubpropertyDataType

Gets or sets the data type that is assigned to the column.

System_CAPS_pubpropertyDefault

Gets or sets the default bound to the column.

System_CAPS_pubpropertyDefaultConstraint

Gets a default value for the column.

System_CAPS_pubpropertyDefaultSchema

Gets or sets the default schema that is bound to the column.

System_CAPS_pubpropertyEncryptionAlgorithm

System_CAPS_pubpropertyEncryptionType

System_CAPS_pubpropertyExecutionManager

(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyExtendedProperties

Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property for the Column object.

System_CAPS_pubpropertyGeneratedAlwaysType

System_CAPS_pubpropertyID

Gets the column ID that uniquely identifies the column.

System_CAPS_pubpropertyIdentity

Gets or sets the Boolean property value that specifies whether the column is an identity column.

System_CAPS_pubpropertyIdentityIncrement

Gets or sets the identity increment for an identity column.

System_CAPS_pubpropertyIdentitySeed

Gets or sets the identity seed for an identity column.

System_CAPS_pubpropertyInPrimaryKey

Gets the Boolean property value that specifies whether the column is included in the definition of a primary key or unique key constraint.

System_CAPS_pubpropertyIsColumnSet

Gets or sets a Boolean value that specifies whether the column is a sparse column that is a member of a column set.

System_CAPS_pubpropertyIsDeterministic

Gets or sets the Boolean property value that specifies whether the value of a computed column can change in subsequent invocations.

System_CAPS_pubpropertyIsEncrypted

System_CAPS_pubpropertyIsFileStream

Gets a T:System.boolean value that represents the FILESTREAM attribute of the column.

System_CAPS_pubpropertyIsForeignKey

Gets the Boolean property value that specifies whether the column is a foreign key.

System_CAPS_pubpropertyIsFullTextIndexed

Gets the Boolean property value that specifies whether the column participates in a full-text index.

System_CAPS_pubpropertyIsHidden

System_CAPS_pubpropertyIsMasked

System_CAPS_pubpropertyIsPersisted

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.

System_CAPS_pubpropertyIsPrecise

Gets or sets the Boolean property value that specifies whether a computed column is a precise value.

System_CAPS_pubpropertyIsSparse

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.

System_CAPS_pubpropertyMaskingFunction

System_CAPS_pubpropertyName

Gets or sets a String value that specifies the name of the column.(Overrides NamedSmoObject.Name.)

System_CAPS_pubpropertyNotForReplication

Gets the Boolean property value that specifies whether the column is participating in replication.

System_CAPS_pubpropertyNullable

Gets or sets the Boolean property value that specifies whether the column can accept null values.

System_CAPS_pubpropertyParent

Gets the SqlSmoObject object that is the parent of the Column object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyRowGuidCol

Gets or sets the Boolean property value that specifies whether the column is automatically updated with a unique GUID value.

System_CAPS_pubpropertyRule

Gets or sets the rule that is bound to the column.

System_CAPS_pubpropertyRuleSchema

Gets or sets the rule schema that is bound to the column.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyStatisticalSemantics

Gets or sets a value to indicate whether a column has been enabled for Semantic Extraction and Indexing.

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

Return to top
Show:
© 2016 Microsoft