Column-Klasse
SQL Server 2012
The Column object represents a SQL Server column.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Der Column-Typ macht folgende Elemente verfügbar.
| Name | Beschreibung | |
|---|---|---|
 | 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. |
| Name | Beschreibung | |
|---|---|---|
| AnsiPaddingStatus | Gets 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 or sets the default bound to the column. |
| DefaultConstraint | Gets a default value for the column. |
| DefaultSchema | Gets or sets the default schema that is bound to the column. |
| 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 a Boolean value that specifies whether the column is a sparse column that is a member of a column 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 this is a sparse column. For more information about sparse columns, see Verwenden von Spalten mit geringer Dichte. |
| Name | Gets or sets a String value that specifies the name of the column. (Überschreibt NamedSmoObject.Name.) |
| 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. |
| 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. (Geerbt von 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. |
| State | Gets the state of the referenced object. (Geerbt von SmoObjectBase.) |
| StatisticalSemantics | Gets or sets a value to indicate whether a column has been enabled for Semantic Extraction and Indexing. |
| Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Geerbt von SqlSmoObject.) |
| UserData | Gets or sets user-defined data associated with the referenced object. (Geerbt von SmoObjectBase.) |
| Name | Beschreibung | |
|---|---|---|
| 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. |
| BindDefault | Binds a default to the column. |
| BindRule | Binds a rule to the column. |
| Create | Creates a column on the instance of Microsoft SQL Server as defined by the Column object. |
| Discover | Discovers a list of type Object. (Geerbt von SqlSmoObject.) |
| Drop | Drops the column. |
| EnumForeignKeys | Enumerates a list of foreign keys that reference the column. |
| EnumIndexes | Enumerates a list of indexes that include the column. |
| EnumUserPermissions | Enumerates a list of permissions for a specified user. |
| Equals | (Geerbt von Object.) |
| FormatSqlVariant | Formats an object as SqlVariant type. (Geerbt von SqlSmoObject.) |
| GetContextDB | Gets the context database that is associated with this object. (Geerbt von SqlSmoObject.) |
| GetDBName | Gets the database name that is associated with the object. (Geerbt von SqlSmoObject.) |
| GetHashCode | (Geerbt von Object.) |
| GetPropValue | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
| GetPropValueOptional | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
| GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
| GetServerObject | Gets the server of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
| GetType | (Geerbt von Object.) |
| Initialize() | Initializes the object and forces the properties be loaded. (Geerbt von SqlSmoObject.) |
| Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Geerbt von SqlSmoObject.) |
| IsObjectInitialized | Verifies whether the object has been initialized. (Geerbt von SqlSmoObject.) |
| IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Geerbt von SqlSmoObject.) |
| MarkForDrop | Marks the column to be dropped when the Alter method is run on the column's parent Table object. |
| Refresh | Refreshes the Column object properties. (Überschreibt ScriptNameObjectBase.Refresh().) |
| Rename | Renames the column. |
| SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (Geerbt von SqlSmoObject.) |
| ToString | Returns a String that represents the referenced object. (Geerbt von SqlSmoObject.) |
| UnbindDefault | Unbinds the currently bound default from the column. |
| UnbindRule | Unbinds the currently bound rule from the column. |
| 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 | Validates the state of an object. (Geerbt von SmoObjectBase.) |
| Name | Beschreibung | |
|---|---|---|
| PropertyChanged | Represents the event that occurs when a property is changed. (Geerbt von SqlSmoObject.) |
| PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (Geerbt von SqlSmoObject.) |
| Name | Beschreibung | |
|---|---|---|
| IAlienObject.Discover | Discovers any dependencies. Verweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. (Geerbt von SqlSmoObject.) |
| IAlienObject.GetDomainRoot | Returns the root of the domain. (Geerbt von SqlSmoObject.) |
| IAlienObject.GetParent | Gets the parent of this object. Verweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. (Geerbt von SqlSmoObject.) |
| IAlienObject.GetPropertyType | Gets the type of the specified property. (Geerbt von SqlSmoObject.) |
| IAlienObject.GetPropertyValue | Gets the value of the specified property. (Geerbt von SqlSmoObject.) |
| IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Verweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. (Geerbt von SqlSmoObject.) |
| IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (Geerbt von SqlSmoObject.) |
| IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (Geerbt von SqlSmoObject.) |
| IAlienObject.SetPropertyValue | Sets the property value. (Geerbt von SqlSmoObject.) |
| ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (Geerbt von SqlSmoObject.) |
 | ISfcSupportsDesignMode.IsDesignMode | Gets a Boolean value that specifies whether the column supports design mode. |
To get Column object properties, users can be a member of the public fixed server role.
To do any of the following, users must have ALTER permission on the parent table, or be a member of the db_owner fixed database role:
Set Column object properties and run the Alter method
Create a column
Drop a column
Thread Safety
Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Bei Instanzmembern ist die Threadsicherheit nicht gewährleistet.
