Dela via

  • Artikel

Column Members

Include Protected Members
Include Inherited Members

The Column object represents a SQL Server column.

The Column type exposes the following members.

Constructors

  Name Description
Public method Column() Initializes a new instance of the Column class.
Public method Column(SqlSmoObject, String) Initializes a new instance of the Column class that has the specified parent and specified name.
Public method Column(SqlSmoObject, String, DataType) Initializes a new instance of the Column class that has the specified parent and specified name.
Public method 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.

Top

Methods

  Name Description
Protected method AddDatabaseContext(StringCollection) (Inherited from SqlSmoObject.)
Public method AddDefaultConstraint() Adds a default constraint to the column.
Public method AddDefaultConstraint(String) Adds a default constraint to the column.
Public method Alter() Updates any Column object property changes on the instance of SQL Server.
Protected method AlterImpl() (Inherited from SqlSmoObject.)
Protected method AlterImplFinish(StringCollection, ScriptingOptions) (Inherited from SqlSmoObject.)
Protected method AlterImplInit(StringCollection%, ScriptingOptions%) (Inherited from SqlSmoObject.)
Protected method AlterImplWorker() (Inherited from SqlSmoObject.)
Protected method AppendCommaText(StringBuilder, String, Boolean%, String) (Inherited from ScriptNameObjectBase.)
Protected method AppendWithCommaText(StringBuilder, String, Boolean%) (Inherited from ScriptNameObjectBase.)
Protected method AppendWithOption(StringBuilder, String, String, Boolean%) (Inherited from ScriptNameObjectBase.)
Public method BindDefault(String, String) Binds a default to the column.
Protected method BindDefaultImpl(String, String, Boolean) (Inherited from SqlSmoObject.)
Public method BindRule(String, String) Binds a rule to the column.
Protected method BindRuleImpl(String, String, Boolean) (Inherited from SqlSmoObject.)
Protected method CheckCollation(String, ScriptingOptions) (Inherited from SqlSmoObject.)
Protected method CheckObjectDirty() (Inherited from ScriptNameObjectBase.)
Protected method CheckObjectState() Validates the state of the referenced object. (Inherited from SqlSmoObject.)
Protected method 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. (Inherited from SqlSmoObject.)
Protected method CheckObjectStateImpl(Boolean) (Inherited from SqlSmoObject.)
Protected method CheckTextCorectness(String, Boolean, Boolean, array<String[], DdlTextParserHeaderInfo%) (Inherited from ScriptNameObjectBase.)
Protected method CheckTextModeSupport() (Inherited from ScriptNameObjectBase.)
Protected method CheckVersion100() (Inherited from SqlSmoObject.)
Protected method CheckVersion80() Checks the validity of the object on SQL Server 2000. (Inherited from SqlSmoObject.)
Protected method CheckVersion80SP3() Checks the validity of the object on SQL Server 2000 SP3. (Inherited from SqlSmoObject.)
Protected method CheckVersion90() Check the validity of the object on SQL Server 2005. (Inherited from SqlSmoObject.)
Protected method CheckVersionBelow90() (Inherited from SqlSmoObject.)
Protected method CleanObject() Cleans the referenced object. (Inherited from ScriptNameObjectBase.)
Public method Create() Creates a column on the instance of Microsoft SQL Server as defined by the Column object.
Protected method CreateImpl() (Inherited from SqlSmoObject.)
Protected method CreateImplFinish(StringCollection, ScriptingOptions) (Inherited from SqlSmoObject.)
Protected method CreateImplInit(StringCollection%, ScriptingOptions%) (Inherited from SqlSmoObject.)
Public method Discover() (Inherited from SqlSmoObject.)
Public method Drop() Drops the column.
Protected method DropImpl() (Inherited from SqlSmoObject.)
Protected method DropImplWorker(Urn%) (Inherited from SqlSmoObject.)
Public method EnumForeignKeys() Enumerates a list of foreign keys that reference the column.
Public method EnumIndexes() Enumerates a list of indexes that include the column.
Protected method EnumScriptImpl(ScriptingOptions) (Inherited from SqlSmoObject.)
Protected method EnumScriptImplWorker(ScriptingOptions) (Inherited from SqlSmoObject.)
Public method EnumUserPermissions(String) Enumerates a list of permissions for a specified user.
Public method Equals(Object) (Inherited from Object.)
Protected method Finalize() (Inherited from Object.)
Protected method ForceTextModeOnTextBody() Enforces text mode on the text body. (Inherited from ScriptNameObjectBase.)
Protected method FormatSqlVariant(Object) (Inherited from SqlSmoObject.)
Protected method GenerateDataSpaceFileStreamScript(StringBuilder, ScriptingOptions, Boolean) (Inherited from SqlSmoObject.)
Protected method GenerateDataSpaceScript(StringBuilder, ScriptingOptions) (Inherited from SqlSmoObject.)
Protected method GetBindDefaultScript(ScriptingOptions, String, String, Boolean) (Inherited from SqlSmoObject.)
Protected method GetBindRuleScript(ScriptingOptions, String, String, Boolean) (Inherited from SqlSmoObject.)
Protected method GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Inherited from SqlSmoObject.)
Protected method GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (Inherited from SqlSmoObject.)
Protected method GetBraketNameForText() (Inherited from ScriptNameObjectBase.)
Protected method GetDateTimeParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Inherited from SqlSmoObject.)
Protected method GetDateTimeParameterAsInt(StringBuilder, ScriptingOptions, String, String, Int32%) (Inherited from SqlSmoObject.)
Protected method GetDBName() Gets the database name that is associated with the object. (Inherited from SqlSmoObject.)
Protected method GetEnumParameter(StringBuilder, ScriptingOptions, String, String, Type, Int32%) (Inherited from SqlSmoObject.)
Protected method GetFragOptionString(FragmentationOption) (Inherited from SqlSmoObject.)
Protected method GetGuidParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Inherited from SqlSmoObject.)
Public method GetHashCode() (Inherited from Object.)
Protected method GetIsTextDirty() Determines whether the text value is consistent with stored value. (Inherited from ScriptNameObjectBase.)
Protected method GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Inherited from SqlSmoObject.)
Protected method GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (Inherited from SqlSmoObject.)
Protected method GetPropValue(String) (Inherited from SqlSmoObject.)
Protected method GetPropValueOptional(String) (Inherited from SqlSmoObject.)
Protected method GetPropValueOptionalAllowNull(String) (Inherited from SqlSmoObject.)
Protected method GetRealValue(Property, Object) (Inherited from SqlSmoObject.)
Protected method GetScriptIncludeExists(ScriptingOptions, String, Boolean) (Inherited from ScriptNameObjectBase.)
Protected method GetScriptingOptionsForCreate() (Inherited from SqlSmoObject.)
Protected method GetServerName() Gets the name of the instance of SQL Server with which the object is associated. (Inherited from SqlSmoObject.)
Protected method GetServerObject() (Inherited from SqlSmoObject.)
Protected method GetSqlServerVersionName() Gets the version name of the instance of SQL Server with which the object is associated. (Inherited from SqlSmoObject.)
Protected method GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) (Inherited from SqlSmoObject.)
Protected method GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) (Inherited from SqlSmoObject.)
Protected method GetTextBody() Returns the text body. (Inherited from ScriptNameObjectBase.)
Protected method GetTextBody(Boolean) Returns the text body. (Inherited from ScriptNameObjectBase.)
Protected method GetTextForScript(ScriptingOptions, Boolean, array<String[]) Gets the text for scripting. (Inherited from ScriptNameObjectBase.)
Protected method GetTextForScript(ScriptingOptions, Boolean, array<String[], Boolean) (Inherited from ScriptNameObjectBase.)
Protected method GetTextHeader(Boolean) Returns the text header. (Inherited from ScriptNameObjectBase.)
Protected method GetTextMode() Determines whether the script name is using text mode. (Inherited from ScriptNameObjectBase.)
Protected method GetTextProperty(String) (Inherited from ScriptNameObjectBase.)
Protected method GetTextProperty(String, ScriptingOptions) (Inherited from ScriptNameObjectBase.)
Protected method GetTimeSpanParameterAsInt(StringBuilder, ScriptingOptions, String, String, Int32%) (Inherited from SqlSmoObject.)
Public method GetType() (Inherited from Object.)
Protected method GetUrnRecursive(StringBuilder) (Inherited from SqlSmoObject.)
Protected method GetUrnRecursive(StringBuilder, UrnIdOption) (Inherited from SqlSmoObject.)
Protected method ImplInitialize(array<String[], array<OrderBy[]) (Inherited from SqlSmoObject.)
Public method Initialize() Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.)
Public method Initialize(Boolean) Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.)
Protected method IsObjectDirty() Determines whether the referenced object is consistent with the stored object. (Inherited from ScriptNameObjectBase.)
Protected method IsObjectInitialized() Verifies whether the object has been initialized. (Inherited from SqlSmoObject.)
Protected method IsObjectInSpace() Verifies whether the object is isolated or connected to the instance of SQL Server. (Inherited from SqlSmoObject.)
Protected method IsVersion80SP3() (Inherited from SqlSmoObject.)
Protected method MarkDropped() (Inherited from SqlSmoObject.)
Public method MarkForDrop(Boolean) Marks the column to be dropped when the Alter method is run on the column's parent Table object.
Protected method MarkForDropImpl(Boolean) (Inherited from SqlSmoObject.)
Protected method MemberwiseClone() (Inherited from Object.)
Protected method PostAlter() (Inherited from SqlSmoObject.)
Protected method PostCreate() (Inherited from SqlSmoObject.)
Protected method PostDrop() (Inherited from SqlSmoObject.)
Public method Refresh() Refreshes the Column object properties. (Overrides ScriptNameObjectBase.Refresh().)
Public method Rename(String) Renames the column.
Protected method RenameImpl(String) This method supports the SMO infrastructure and is not intended to be used directly from your code. (Inherited from NamedSmoObject.)
Protected method RenameImplWorker(String) This method supports the SMO infrastructure and is not intended to be used directly from your code. (Inherited from NamedSmoObject.)
Protected method ScriptAlter(StringCollection, ScriptingOptions) (Inherited from SqlSmoObject.)
Protected method ScriptAnsiQI(SqlSmoObject, ScriptingOptions, StringCollection, StringBuilder, Object%, Object%) (Inherited from ScriptNameObjectBase.)
Protected method ScriptChangeOwner(StringCollection, ScriptingOptions) This method supports the SMO infrastructure and is not intended to be used directly from your code. (Inherited from NamedSmoObject.)
Protected method ScriptCreate(StringCollection, ScriptingOptions) (Inherited from SqlSmoObject.)
Protected method ScriptDdl(StringCollection, ScriptingOptions) (Inherited from SqlSmoObject.)
Protected method ScriptDrop(StringCollection, ScriptingOptions) (Inherited from SqlSmoObject.)
Protected method ScriptImpl() (Inherited from SqlSmoObject.)
Protected method ScriptImpl(ScriptingOptions) (Inherited from SqlSmoObject.)
Protected method ScriptImplWorker(ScriptingOptions) (Inherited from SqlSmoObject.)
Protected method ScriptInformativeHeaders(ScriptingOptions, StringBuilder) (Inherited from ScriptNameObjectBase.)
Protected method ScriptRename(StringCollection, ScriptingOptions, String) This method supports the SMO infrastructure and is not intended to be used directly from your code. (Inherited from NamedSmoObject.)
Protected method SetCollectionTextMode(Boolean, SmoCollectionBase) Sets the collection text mode. (Inherited from ScriptNameObjectBase.)
Protected method SetParentImpl(SqlSmoObject) (Inherited from SqlSmoObject.)
Protected method SetTextBody(String) Specifies the text body. (Inherited from ScriptNameObjectBase.)
Protected method SetTextHeader(String) Specifies the text header. (Inherited from ScriptNameObjectBase.)
Protected method SetTextMode(Boolean, array<SmoCollectionBase[]) Specifies the text mode. (Inherited from ScriptNameObjectBase.)
Protected method SwitchTextMode(Boolean, array<SmoCollectionBase[]) Switches the text mode. (Inherited from ScriptNameObjectBase.)
Protected method ThrowIfTextIsDirtyForAlter() (Inherited from ScriptNameObjectBase.)
Public method ToString() Returns a String that represents the referenced object. (Inherited from SqlSmoObject.)
Protected method TouchImpl() (Inherited from SqlSmoObject.)
Public method UnbindDefault() Unbinds the currently bound default from the column.
Protected method UnbindDefaultImpl(Boolean) (Inherited from SqlSmoObject.)
Public method UnbindRule() Unbinds the currently bound rule from the column.
Protected method UnbindRuleImpl(Boolean) (Inherited from SqlSmoObject.)
Public method UpdateStatistics() Updates Statistic objects that monitor this column.
Public method UpdateStatistics(StatisticsScanType) Updates Statistic objects that monitor this column.
Public method UpdateStatistics(StatisticsScanType, Int32) Updates Statistic objects that monitor this column using a sampled scan.
Public method UpdateStatistics(StatisticsScanType, Int32, Boolean) Updates Statistic objects that monitor this column using a sampled scan.
Public method Validate(String, array<Object[]) (Inherited from SmoObjectBase.)

Top

Fields

  Name Description
Protected field m_ExtendedProperties (Inherited from SqlSmoObject.)

Top

Properties

  Name Description
Public property AnsiPaddingStatus Gets or sets 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 the default bound to the column.
Public property DefaultConstraint Gets or sets a default value for the column.
Public property DefaultSchema Gets or sets the default schema that is bound to the column.
Protected property ExecuteForScalar Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Inherited from SqlSmoObject.)
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 the Boolean property value that specifies whether the column has been 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 the column value is sparse.
Protected property IsTouched Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Inherited from SqlSmoObject.)
Public property Name Gets or sets the name of the object. (Inherited from NamedSmoObject.)
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.
Protected property 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. (Inherited from SqlSmoObject.)
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.
Protected property ScalarResult Gets the scalar result for the referenced object. (Inherited from SqlSmoObject.)
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
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

Events

  Name Description
Public event PropertyChanged (Inherited from SqlSmoObject.)
Public event PropertyMetadataChanged (Inherited from SqlSmoObject.)

Top

Explicit Interface Implementations

  Name Description
Explicit interface implemetationPrivate method IAlienObjectDiscover() (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate method IAlienObjectGetParent() (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate method IAlienObjectGetProperty(String) (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate method ISfcPropertyProviderGetPropertySet() (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate method IAlienObjectGetUrn() (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate method IAlienObjectResolve(String) (Inherited from SqlSmoObject.)
Explicit interface implemetationPrivate method IAlienObjectSetProperty(Object, Object) (Inherited from SqlSmoObject.)

Top