Column 成員
The Column object represents a SQL Server column.
Column 型別公開下列成員。
建構函式
| 名稱 | 描述 | |
|---|---|---|
.gif "公用方法") |
Column() () () () | Initializes a new instance of the Column class. |
|
Column(SqlSmoObject, String) | Initializes a new instance of the Column class that has the specified parent and specified name. |
|
Column(SqlSmoObject, String, DataType) | Initializes a new instance of the Column class that has the specified parent and specified name. |
|
Column(SqlSmoObject, String, DataType, Boolean) | Initializes a new instance of the Column class that uses the specified parent, datayype, and optionally adding the FILESTREAM attribute. |
頂端
方法
.gif "受保護的方法")
頂端
.gif "受保護的欄位")
屬性
| 名稱 | 描述 | |
|---|---|---|
.gif "公用屬性") |
AnsiPaddingStatus | Gets or sets a Boolean property value that specifies whether the ANSI_PADDING_ENABLED column option is active. |
|
Collation | Gets or sets the default collation that is used by the column. |
|
Computed | Gets the Boolean property value that specifies whether the column is the product of computed expression |
|
ComputedText | Gets or sets the Transact-SQL expression that is used to generate the value of a computed column |
|
DataType | Gets or sets the data type that is assigned to the column. |
|
Default | Gets the default bound to the column. |
|
DefaultConstraint | Gets or sets a default value for the column. |
|
DefaultSchema | Gets or sets the default schema that is bound to the column. |
.gif "受保護的屬性") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (繼承自 SqlSmoObject。) |
|
ExtendedProperties | Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property for the Column object. |
|
ID | Gets the column ID that uniquely identifies the column. |
|
Identity | Gets or sets the Boolean property value that specifies whether the column is an identity column. |
|
IdentityIncrement | Gets or sets the identity increment for an identity column. |
|
IdentitySeed | Gets or sets the identity seed for an identity column. |
|
InPrimaryKey | Gets the Boolean property value that specifies whether the column is included in the definition of a primary key or unique key constraint. |
|
IsColumnSet | Gets or sets the Boolean property value that specifies whether the column has been set. |
|
IsDeterministic | Gets or sets the Boolean property value that specifies whether the value of a computed column can change in subsequent invocations. |
|
IsFileStream | Gets a boolean value that represents the FILESTREAM attribute of the column. |
|
IsForeignKey | Gets the Boolean property value that specifies whether the column is a foreign key. |
|
IsFullTextIndexed | Gets the Boolean property value that specifies whether the column participates in a full-text index. |
|
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. |
|
IsPrecise | Gets or sets the Boolean property value that specifies whether a computed column is a precise value. |
|
IsSparse | Gets or sets the Boolean property value that specifies whether the column value is sparse. |
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (繼承自 SqlSmoObject。) |
|
Name | Gets or sets the name of the object. (繼承自 NamedSmoObject。) |
|
NotForReplication | Gets the Boolean property value that specifies whether the column is participating in replication. |
|
Nullable | Gets or sets the Boolean property value that specifies whether the column can accept null values. |
|
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (繼承自 SqlSmoObject。) |
|
Parent | Gets the SqlSmoObject object that is the parent of the Column object. |
|
Properties | Gets a collection of Property objects that represent the object properties. (繼承自 SqlSmoObject。) |
|
RowGuidCol | Gets or sets the Boolean property value that specifies whether the column is automatically updated with a unique GUID value. |
|
Rule | Gets or sets the rule that is bound to the column. |
|
RuleSchema | Gets or sets the rule schema that is bound to the column. |
|
ScalarResult | Gets the scalar result for the referenced object. (繼承自 SqlSmoObject。) |
|
State | Gets the state of the referenced object. (繼承自 SmoObjectBase。) |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (繼承自 SqlSmoObject。) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (繼承自 SmoObjectBase。) |
頂端
.gif "公用事件")
明確繼承實作
| 名稱 | 描述 | |
|---|---|---|
.gif "明確介面實作") .gif "私用方法") |
IAlienObjectDiscover | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetParent | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetProperty | (繼承自 SqlSmoObject。) |
|
ISfcPropertyProviderGetPropertySet | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetUrn | (繼承自 SqlSmoObject。) |
|
IAlienObjectResolve | (繼承自 SqlSmoObject。) |
|
IAlienObjectSetProperty | (繼承自 SqlSmoObject。) |
頂端