Membres Column
The Column object represents a SQL Server column.
Le type Column expose les membres suivants.
Constructeurs
| Nom | Description | |
|---|---|---|
.gif "Méthode publique") |
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. |
Haut de la page
Méthodes
| Nom | Description | |
|---|---|---|
.gif "Méthode protégée") |
AddDatabaseContext | (Hérité de SqlSmoObject.) |
|
AddDefaultConstraint() () () () | Adds a default constraint to the column. |
|
AddDefaultConstraint(String) | Adds a default constraint to the column. |
|
Alter | Updates any Column object property changes on the instance of SQL Server. |
|
AlterImpl | (Hérité de SqlSmoObject.) |
|
AlterImplFinish | (Hérité de SqlSmoObject.) |
|
AlterImplInit | (Hérité de SqlSmoObject.) |
|
AlterImplWorker | (Hérité de SqlSmoObject.) |
|
AppendCommaText | (Hérité de ScriptNameObjectBase.) |
|
AppendWithCommaText | (Hérité de ScriptNameObjectBase.) |
|
AppendWithOption | (Hérité de ScriptNameObjectBase.) |
|
BindDefault | Binds a default to the column. |
|
BindDefaultImpl | (Hérité de SqlSmoObject.) |
|
BindRule | Binds a rule to the column. |
|
BindRuleImpl | (Hérité de SqlSmoObject.) |
|
CheckCollation | (Hérité de SqlSmoObject.) |
|
CheckObjectDirty | (Hérité de ScriptNameObjectBase.) |
|
CheckObjectState() () () () | Validates the state of the referenced object. (Hérité de SqlSmoObject.) |
|
CheckObjectState(Boolean) | Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. (Hérité de SqlSmoObject.) |
|
CheckObjectStateImpl | (Hérité de SqlSmoObject.) |
|
CheckTextCorectness | (Hérité de ScriptNameObjectBase.) |
|
CheckTextModeSupport | (Hérité de ScriptNameObjectBase.) |
|
CheckVersion100 | (Hérité de SqlSmoObject.) |
|
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (Hérité de SqlSmoObject.) |
|
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (Hérité de SqlSmoObject.) |
|
CheckVersion90 | Check the validity of the object on SQL Server 2005. (Hérité de SqlSmoObject.) |
|
CheckVersionBelow90 | (Hérité de SqlSmoObject.) |
|
CleanObject | Cleans the referenced object. (Hérité de ScriptNameObjectBase.) |
|
Create | Creates a column on the instance of Microsoft SQL Server as defined by the Column object. |
|
CreateImpl | (Hérité de SqlSmoObject.) |
|
CreateImplFinish | (Hérité de SqlSmoObject.) |
|
CreateImplInit | (Hérité de SqlSmoObject.) |
|
Discover | (Hérité de SqlSmoObject.) |
|
Drop | Drops the column. |
|
DropImpl | (Hérité de SqlSmoObject.) |
|
DropImplWorker | (Hérité de SqlSmoObject.) |
|
EnumForeignKeys | Enumerates a list of foreign keys that reference the column. |
|
EnumIndexes | Enumerates a list of indexes that include the column. |
|
EnumScriptImpl | (Hérité de SqlSmoObject.) |
|
EnumScriptImplWorker | (Hérité de SqlSmoObject.) |
|
EnumUserPermissions | Enumerates a list of permissions for a specified user. |
|
Equals | (Hérité de Object.) |
|
Finalize | (Hérité de Object.) |
|
ForceTextModeOnTextBody | Enforces text mode on the text body. (Hérité de ScriptNameObjectBase.) |
|
FormatSqlVariant | (Hérité de SqlSmoObject.) |
|
GenerateDataSpaceFileStreamScript | (Hérité de SqlSmoObject.) |
|
GenerateDataSpaceScript | (Hérité de SqlSmoObject.) |
|
GetBindDefaultScript | (Hérité de SqlSmoObject.) |
|
GetBindRuleScript | (Hérité de SqlSmoObject.) |
|
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Hérité de SqlSmoObject.) |
|
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Hérité de SqlSmoObject.) |
|
GetBraketNameForText | (Hérité de ScriptNameObjectBase.) |
|
GetDateTimeParameter | (Hérité de SqlSmoObject.) |
|
GetDateTimeParameterAsInt | (Hérité de SqlSmoObject.) |
|
GetDBName | Gets the database name that is associated with the object. (Hérité de SqlSmoObject.) |
|
GetEnumParameter | (Hérité de SqlSmoObject.) |
|
GetFragOptionString | (Hérité de SqlSmoObject.) |
|
GetGuidParameter | (Hérité de SqlSmoObject.) |
|
GetHashCode | (Hérité de Object.) |
|
GetIsTextDirty | Determines whether the text value is consistent with stored value. (Hérité de ScriptNameObjectBase.) |
|
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Hérité de SqlSmoObject.) |
|
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Hérité de SqlSmoObject.) |
|
GetPropValue | (Hérité de SqlSmoObject.) |
|
GetPropValueOptional | (Hérité de SqlSmoObject.) |
|
GetPropValueOptionalAllowNull | (Hérité de SqlSmoObject.) |
|
GetRealValue | (Hérité de SqlSmoObject.) |
|
GetScriptIncludeExists | (Hérité de ScriptNameObjectBase.) |
|
GetScriptingOptionsForCreate | (Hérité de SqlSmoObject.) |
|
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (Hérité de SqlSmoObject.) |
|
GetServerObject | (Hérité de SqlSmoObject.) |
|
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (Hérité de SqlSmoObject.) |
|
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Hérité de SqlSmoObject.) |
|
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Hérité de SqlSmoObject.) |
|
GetTextBody() () () () | Returns the text body. (Hérité de ScriptNameObjectBase.) |
|
GetTextBody(Boolean) | Returns the text body. (Hérité de ScriptNameObjectBase.) |
|
GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] []) | Gets the text for scripting. (Hérité de ScriptNameObjectBase.) |
|
GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] [], Boolean) | (Hérité de ScriptNameObjectBase.) |
|
GetTextHeader | Returns the text header. (Hérité de ScriptNameObjectBase.) |
|
GetTextMode | Determines whether the script name is using text mode. (Hérité de ScriptNameObjectBase.) |
|
GetTextProperty(String) | (Hérité de ScriptNameObjectBase.) |
|
GetTextProperty(String, ScriptingOptions) | (Hérité de ScriptNameObjectBase.) |
|
GetTimeSpanParameterAsInt | (Hérité de SqlSmoObject.) |
|
GetType | (Hérité de Object.) |
|
GetUrnRecursive(StringBuilder) | (Hérité de SqlSmoObject.) |
|
GetUrnRecursive(StringBuilder, UrnIdOption) | (Hérité de SqlSmoObject.) |
|
ImplInitialize | (Hérité de SqlSmoObject.) |
|
Initialize() () () () | Initializes the object and forces the properties be loaded. (Hérité de SqlSmoObject.) |
|
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Hérité de SqlSmoObject.) |
|
IsObjectDirty | Determines whether the referenced object is consistent with the stored object. (Hérité de ScriptNameObjectBase.) |
|
IsObjectInitialized | Verifies whether the object has been initialized. (Hérité de SqlSmoObject.) |
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Hérité de SqlSmoObject.) |
|
IsVersion80SP3 | (Hérité de SqlSmoObject.) |
|
MarkDropped | (Hérité de SqlSmoObject.) |
|
MarkForDrop | Marks the column to be dropped when the Alter method is run on the column's parent Table object. |
|
MarkForDropImpl | (Hérité de SqlSmoObject.) |
|
MemberwiseClone | (Hérité de Object.) |
|
PostAlter | (Hérité de SqlSmoObject.) |
|
PostCreate | (Hérité de SqlSmoObject.) |
|
PostDrop | (Hérité de SqlSmoObject.) |
|
Refresh | Refreshes the Column object properties. (Se substitue à ScriptNameObjectBase. . :: . .Refresh() () () ().) |
|
Rename | Renames the column. |
|
RenameImpl | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.) |
|
RenameImplWorker | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.) |
|
ScriptAlter | (Hérité de SqlSmoObject.) |
|
ScriptAnsiQI | (Hérité de ScriptNameObjectBase.) |
|
ScriptChangeOwner | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.) |
|
ScriptCreate | (Hérité de SqlSmoObject.) |
|
ScriptDdl | (Hérité de SqlSmoObject.) |
|
ScriptDrop | (Hérité de SqlSmoObject.) |
|
ScriptImpl() () () () | (Hérité de SqlSmoObject.) |
|
ScriptImpl(ScriptingOptions) | (Hérité de SqlSmoObject.) |
|
ScriptImplWorker | (Hérité de SqlSmoObject.) |
|
ScriptInformativeHeaders | (Hérité de ScriptNameObjectBase.) |
|
ScriptRename | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Hérité de NamedSmoObject.) |
|
SetCollectionTextMode | Sets the collection text mode. (Hérité de ScriptNameObjectBase.) |
|
SetParentImpl | (Hérité de SqlSmoObject.) |
|
SetTextBody | Specifies the text body. (Hérité de ScriptNameObjectBase.) |
|
SetTextHeader | Specifies the text header. (Hérité de ScriptNameObjectBase.) |
|
SetTextMode | Specifies the text mode. (Hérité de ScriptNameObjectBase.) |
|
SwitchTextMode | Switches the text mode. (Hérité de ScriptNameObjectBase.) |
|
ThrowIfTextIsDirtyForAlter | (Hérité de ScriptNameObjectBase.) |
|
ToString | Returns a String that represents the referenced object. (Hérité de SqlSmoObject.) |
|
TouchImpl | (Hérité de SqlSmoObject.) |
|
UnbindDefault | Unbinds the currently bound default from the column. |
|
UnbindDefaultImpl | (Hérité de SqlSmoObject.) |
|
UnbindRule | Unbinds the currently bound rule from the column. |
|
UnbindRuleImpl | (Hérité de SqlSmoObject.) |
|
UpdateStatistics() () () () | Updates Statistic objects that monitor this column. |
|
UpdateStatistics(StatisticsScanType) | Updates Statistic objects that monitor this column. |
|
UpdateStatistics(StatisticsScanType, Int32) | Updates Statistic objects that monitor this column using a sampled scan. |
|
UpdateStatistics(StatisticsScanType, Int32, Boolean) | Updates Statistic objects that monitor this column using a sampled scan. |
|
Validate | (Hérité de SmoObjectBase.) |
Haut de la page
.gif "Champ protégé")
Propriétés
| Nom | Description | |
|---|---|---|
.gif "Propriété publique") |
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 "Propriété protégée") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Hérité de 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. (Hérité de SqlSmoObject.) |
|
Name | Gets or sets the name of the object. (Hérité de 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. (Hérité de 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. (Hérité de 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. (Hérité de SqlSmoObject.) |
|
State | Gets the state of the referenced object. (Hérité de SmoObjectBase.) |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Hérité de SqlSmoObject.) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (Hérité de SmoObjectBase.) |
Haut de la page
Événements
| Nom | Description | |
|---|---|---|
.gif "Événement public") |
PropertyChanged | (Hérité de SqlSmoObject.) |
|
PropertyMetadataChanged | (Hérité de SqlSmoObject.) |
Haut de la page
Implémentations d'interfaces explicites
| Nom | Description | |
|---|---|---|
.gif "Implémentation d'interface explicite") .gif "Méthode privée") |
IAlienObjectDiscover | (Hérité de SqlSmoObject.) |
|
IAlienObjectGetParent | (Hérité de SqlSmoObject.) |
|
IAlienObjectGetProperty | (Hérité de SqlSmoObject.) |
|
ISfcPropertyProviderGetPropertySet | (Hérité de SqlSmoObject.) |
|
IAlienObjectGetUrn | (Hérité de SqlSmoObject.) |
|
IAlienObjectResolve | (Hérité de SqlSmoObject.) |
|
IAlienObjectSetProperty | (Hérité de SqlSmoObject.) |
Haut de la page