Membros Column
The Column object represents a SQL Server column.
O tipo Column expõe os seguintes membros.
Construtores
Nome | Descrição | |
---|---|---|
![]() |
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. |
Início
Métodos
Nome | Descrição | |
---|---|---|
![]() |
AddDatabaseContext | (Herdado 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 | (Herdado de SqlSmoObject.) |
![]() |
AlterImplFinish | (Herdado de SqlSmoObject.) |
![]() |
AlterImplInit | (Herdado de SqlSmoObject.) |
![]() |
AlterImplWorker | (Herdado de SqlSmoObject.) |
![]() |
AppendCommaText | (Herdado de ScriptNameObjectBase.) |
![]() |
AppendWithCommaText | (Herdado de ScriptNameObjectBase.) |
![]() |
AppendWithOption | (Herdado de ScriptNameObjectBase.) |
![]() |
BindDefault | Binds a default to the column. |
![]() |
BindDefaultImpl | (Herdado de SqlSmoObject.) |
![]() |
BindRule | Binds a rule to the column. |
![]() |
BindRuleImpl | (Herdado de SqlSmoObject.) |
![]() |
CheckCollation | (Herdado de SqlSmoObject.) |
![]() |
CheckObjectDirty | (Herdado de ScriptNameObjectBase.) |
![]() |
CheckObjectState() () () () | Validates the state of the referenced object. (Herdado 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. (Herdado de SqlSmoObject.) |
![]() |
CheckObjectStateImpl | (Herdado de SqlSmoObject.) |
![]() |
CheckTextCorectness | (Herdado de ScriptNameObjectBase.) |
![]() |
CheckTextModeSupport | (Herdado de ScriptNameObjectBase.) |
![]() |
CheckVersion100 | (Herdado de SqlSmoObject.) |
![]() |
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (Herdado de SqlSmoObject.) |
![]() |
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (Herdado de SqlSmoObject.) |
![]() |
CheckVersion90 | Check the validity of the object on SQL Server 2005. (Herdado de SqlSmoObject.) |
![]() |
CheckVersionBelow90 | (Herdado de SqlSmoObject.) |
![]() |
CleanObject | Cleans the referenced object. (Herdado de ScriptNameObjectBase.) |
![]() |
Create | Creates a column on the instance of Microsoft SQL Server as defined by the Column object. |
![]() |
CreateImpl | (Herdado de SqlSmoObject.) |
![]() |
CreateImplFinish | (Herdado de SqlSmoObject.) |
![]() |
CreateImplInit | (Herdado de SqlSmoObject.) |
![]() |
Discover | (Herdado de SqlSmoObject.) |
![]() |
Drop | Drops the column. |
![]() |
DropImpl | (Herdado de SqlSmoObject.) |
![]() |
DropImplWorker | (Herdado de SqlSmoObject.) |
![]() |
EnumForeignKeys | Enumerates a list of foreign keys that reference the column. |
![]() |
EnumIndexes | Enumerates a list of indexes that include the column. |
![]() |
EnumScriptImpl | (Herdado de SqlSmoObject.) |
![]() |
EnumScriptImplWorker | (Herdado de SqlSmoObject.) |
![]() |
EnumUserPermissions | Enumerates a list of permissions for a specified user. |
![]() |
Equals | (Herdado de Object.) |
![]() |
Finalize | (Herdado de Object.) |
![]() |
ForceTextModeOnTextBody | Enforces text mode on the text body. (Herdado de ScriptNameObjectBase.) |
![]() |
FormatSqlVariant | (Herdado de SqlSmoObject.) |
![]() |
GenerateDataSpaceFileStreamScript | (Herdado de SqlSmoObject.) |
![]() |
GenerateDataSpaceScript | (Herdado de SqlSmoObject.) |
![]() |
GetBindDefaultScript | (Herdado de SqlSmoObject.) |
![]() |
GetBindRuleScript | (Herdado de SqlSmoObject.) |
![]() |
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Herdado de SqlSmoObject.) |
![]() |
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Herdado de SqlSmoObject.) |
![]() |
GetBraketNameForText | (Herdado de ScriptNameObjectBase.) |
![]() |
GetDateTimeParameter | (Herdado de SqlSmoObject.) |
![]() |
GetDateTimeParameterAsInt | (Herdado de SqlSmoObject.) |
![]() |
GetDBName | Gets the database name that is associated with the object. (Herdado de SqlSmoObject.) |
![]() |
GetEnumParameter | (Herdado de SqlSmoObject.) |
![]() |
GetFragOptionString | (Herdado de SqlSmoObject.) |
![]() |
GetGuidParameter | (Herdado de SqlSmoObject.) |
![]() |
GetHashCode | (Herdado de Object.) |
![]() |
GetIsTextDirty | Determines whether the text value is consistent with stored value. (Herdado de ScriptNameObjectBase.) |
![]() |
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Herdado de SqlSmoObject.) |
![]() |
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Herdado de SqlSmoObject.) |
![]() |
GetPropValue | (Herdado de SqlSmoObject.) |
![]() |
GetPropValueOptional | (Herdado de SqlSmoObject.) |
![]() |
GetPropValueOptionalAllowNull | (Herdado de SqlSmoObject.) |
![]() |
GetRealValue | (Herdado de SqlSmoObject.) |
![]() |
GetScriptIncludeExists | (Herdado de ScriptNameObjectBase.) |
![]() |
GetScriptingOptionsForCreate | (Herdado de SqlSmoObject.) |
![]() |
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (Herdado de SqlSmoObject.) |
![]() |
GetServerObject | (Herdado de SqlSmoObject.) |
![]() |
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (Herdado de SqlSmoObject.) |
![]() |
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Herdado de SqlSmoObject.) |
![]() |
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Herdado de SqlSmoObject.) |
![]() |
GetTextBody() () () () | Returns the text body. (Herdado de ScriptNameObjectBase.) |
![]() |
GetTextBody(Boolean) | Returns the text body. (Herdado de ScriptNameObjectBase.) |
![]() |
GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] []) | Gets the text for scripting. (Herdado de ScriptNameObjectBase.) |
![]() |
GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] [], Boolean) | (Herdado de ScriptNameObjectBase.) |
![]() |
GetTextHeader | Returns the text header. (Herdado de ScriptNameObjectBase.) |
![]() |
GetTextMode | Determines whether the script name is using text mode. (Herdado de ScriptNameObjectBase.) |
![]() |
GetTextProperty(String) | (Herdado de ScriptNameObjectBase.) |
![]() |
GetTextProperty(String, ScriptingOptions) | (Herdado de ScriptNameObjectBase.) |
![]() |
GetTimeSpanParameterAsInt | (Herdado de SqlSmoObject.) |
![]() |
GetType | (Herdado de Object.) |
![]() |
GetUrnRecursive(StringBuilder) | (Herdado de SqlSmoObject.) |
![]() |
GetUrnRecursive(StringBuilder, UrnIdOption) | (Herdado de SqlSmoObject.) |
![]() |
ImplInitialize | (Herdado de SqlSmoObject.) |
![]() |
Initialize() () () () | Initializes the object and forces the properties be loaded. (Herdado de SqlSmoObject.) |
![]() |
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Herdado de SqlSmoObject.) |
![]() |
IsObjectDirty | Determines whether the referenced object is consistent with the stored object. (Herdado de ScriptNameObjectBase.) |
![]() |
IsObjectInitialized | Verifies whether the object has been initialized. (Herdado de SqlSmoObject.) |
![]() |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Herdado de SqlSmoObject.) |
![]() |
IsVersion80SP3 | (Herdado de SqlSmoObject.) |
![]() |
MarkDropped | (Herdado de SqlSmoObject.) |
![]() |
MarkForDrop | Marks the column to be dropped when the Alter method is run on the column's parent Table object. |
![]() |
MarkForDropImpl | (Herdado de SqlSmoObject.) |
![]() |
MemberwiseClone | (Herdado de Object.) |
![]() |
PostAlter | (Herdado de SqlSmoObject.) |
![]() |
PostCreate | (Herdado de SqlSmoObject.) |
![]() |
PostDrop | (Herdado de SqlSmoObject.) |
![]() |
Refresh | Refreshes the Column object properties. (Substitui ScriptNameObjectBase. . :: . .Refresh() () () ().) |
![]() |
Rename | Renames the column. |
![]() |
RenameImpl | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Herdado de NamedSmoObject.) |
![]() |
RenameImplWorker | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Herdado de NamedSmoObject.) |
![]() |
ScriptAlter | (Herdado de SqlSmoObject.) |
![]() |
ScriptAnsiQI | (Herdado de ScriptNameObjectBase.) |
![]() |
ScriptChangeOwner | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Herdado de NamedSmoObject.) |
![]() |
ScriptCreate | (Herdado de SqlSmoObject.) |
![]() |
ScriptDdl | (Herdado de SqlSmoObject.) |
![]() |
ScriptDrop | (Herdado de SqlSmoObject.) |
![]() |
ScriptImpl() () () () | (Herdado de SqlSmoObject.) |
![]() |
ScriptImpl(ScriptingOptions) | (Herdado de SqlSmoObject.) |
![]() |
ScriptImplWorker | (Herdado de SqlSmoObject.) |
![]() |
ScriptInformativeHeaders | (Herdado de ScriptNameObjectBase.) |
![]() |
ScriptRename | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Herdado de NamedSmoObject.) |
![]() |
SetCollectionTextMode | Sets the collection text mode. (Herdado de ScriptNameObjectBase.) |
![]() |
SetParentImpl | (Herdado de SqlSmoObject.) |
![]() |
SetTextBody | Specifies the text body. (Herdado de ScriptNameObjectBase.) |
![]() |
SetTextHeader | Specifies the text header. (Herdado de ScriptNameObjectBase.) |
![]() |
SetTextMode | Specifies the text mode. (Herdado de ScriptNameObjectBase.) |
![]() |
SwitchTextMode | Switches the text mode. (Herdado de ScriptNameObjectBase.) |
![]() |
ThrowIfTextIsDirtyForAlter | (Herdado de ScriptNameObjectBase.) |
![]() |
ToString | Returns a String that represents the referenced object. (Herdado de SqlSmoObject.) |
![]() |
TouchImpl | (Herdado de SqlSmoObject.) |
![]() |
UnbindDefault | Unbinds the currently bound default from the column. |
![]() |
UnbindDefaultImpl | (Herdado de SqlSmoObject.) |
![]() |
UnbindRule | Unbinds the currently bound rule from the column. |
![]() |
UnbindRuleImpl | (Herdado 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 | (Herdado de SmoObjectBase.) |
Início
Propriedades
Nome | Descrição | |
---|---|---|
![]() |
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. |
![]() |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Herdado 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. (Herdado de SqlSmoObject.) |
![]() |
Name | Gets or sets the name of the object. (Herdado 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. (Herdado 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. (Herdado 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. (Herdado de SqlSmoObject.) |
![]() |
State | Gets the state of the referenced object. (Herdado de SmoObjectBase.) |
![]() |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Herdado de SqlSmoObject.) |
![]() |
UserData | Gets or sets user-defined data associated with the referenced object. (Herdado de SmoObjectBase.) |
Início
Eventos
Nome | Descrição | |
---|---|---|
![]() |
PropertyChanged | (Herdado de SqlSmoObject.) |
![]() |
PropertyMetadataChanged | (Herdado de SqlSmoObject.) |
Início
Implementações de interface explícitas
Nome | Descrição | |
---|---|---|
![]() ![]() |
IAlienObjectDiscover | (Herdado de SqlSmoObject.) |
![]() ![]() |
IAlienObjectGetParent | (Herdado de SqlSmoObject.) |
![]() ![]() |
IAlienObjectGetProperty | (Herdado de SqlSmoObject.) |
![]() ![]() |
ISfcPropertyProviderGetPropertySet | (Herdado de SqlSmoObject.) |
![]() ![]() |
IAlienObjectGetUrn | (Herdado de SqlSmoObject.) |
![]() ![]() |
IAlienObjectResolve | (Herdado de SqlSmoObject.) |
![]() ![]() |
IAlienObjectSetProperty | (Herdado de SqlSmoObject.) |
Início