ColumnCollection 类
The ColumnCollection class represents a collection of Column objects that represent all the columns defined on a table.
继承层次结构
System.Object
Microsoft.SqlServer.Management.Smo.AbstractCollectionBase
Microsoft.SqlServer.Management.Smo.SmoCollectionBase
Microsoft.SqlServer.Management.Smo.ArrayListCollectionBase
Microsoft.SqlServer.Management.Smo.ParameterCollectionBase
Microsoft.SqlServer.Management.Smo.ColumnCollection
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
Public NotInheritable Class ColumnCollection _
Inherits ParameterCollectionBase
用法
Dim instance As ColumnCollection
public sealed class ColumnCollection : ParameterCollectionBase
public ref class ColumnCollection sealed : public ParameterCollectionBase
[<SealedAttribute>]
type ColumnCollection =
class
inherit ParameterCollectionBase
end
public final class ColumnCollection extends ParameterCollectionBase
ColumnCollection 类型公开以下成员。
属性
名称 | 说明 | |
---|---|---|
![]() |
Count | Gets the number of objects in the referenced collection. (从 SmoCollectionBase 继承。) |
![]() |
IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (从 SmoCollectionBase 继承。) |
![]() |
Item[Int32] | Gets a Column object in the collection by index number. |
![]() |
Item[String] | Gets a Column object in the collection by name. |
![]() |
Parent | Gets the SqlSmoObject object that is the parent of the ColumnCollection object. |
![]() |
SyncRoot | Gets an object that can be used to synchronize access to the collection. (从 SmoCollectionBase 继承。) |
页首
方法
名称 | 说明 | |
---|---|---|
![]() |
Add(Column) | Adds a Column object to the ColumnCollection collection. |
![]() |
Add(Column, Int32) | Adds a Column object to the ColumnCollection collection at a specified position. |
![]() |
Add(Column, String) | Adds a Column object to the ColumnCollection collection after a specified Column object currently in the ColumnCollection collection. |
![]() |
AddExisting | Adds an object to the collection. (从 AbstractCollectionBase 继承。) |
![]() |
Contains | Validates whether the parameter collection contains a member with a name equal to the specified string. (从 ParameterCollectionBase 继承。) |
![]() |
CopyTo | Copies the collection objects to a one-dimensional array beginning at the index value specified. |
![]() |
Equals | (从 Object 继承。) |
![]() |
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (从 SmoCollectionBase 继承。) |
![]() |
GetHashCode | (从 Object 继承。) |
![]() |
GetType | (从 Object 继承。) |
![]() |
ItemById | Extracts a member from the ColumnCollection collection using a system-defined, unique identifier. |
![]() |
Refresh() | Refreshes the referenced collection. (从 SmoCollectionBase 继承。) |
![]() |
Refresh(Boolean) | Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (从 SmoCollectionBase 继承。) |
![]() |
Remove(String) | Removes a member from the collection with the specified name. (从 ParameterCollectionBase 继承。) |
![]() |
Remove(Column) | Removes a Column object from the ColumnCollection collection. |
![]() |
ToString | (从 Object 继承。) |
页首
字段
名称 | 说明 | |
---|---|---|
![]() |
initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. (从 AbstractCollectionBase 继承。) |
页首
显式接口实现
名称 | 说明 | |
---|---|---|
![]() ![]() |
ICollection.CopyTo | Copies the elements from an instance to an array beginning at the index indicated. (从 SmoCollectionBase 继承。) |
页首
注释
A ColumnCollection object can be used to gain access to a set of columns. You can use the Item property to return a specific Column object.
Thread Safety
此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。但不保证所有实例成员都是线程安全的。
示例
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。