ColumnCollection Members
The ColumnCollection class represents a collection of Column objects that represent all the columns defined on a table.
The following tables list the members exposed by the ColumnCollection type.
Protected Fields
| 名稱 | Description | |
|---|---|---|
.gif "ms219346.protfield(zh-tw,SQL.90).gif") |
initialized | This value supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code. (inherited from AbstractCollectionBase) |
頂端
Public Properties
| 名稱 | Description | |
|---|---|---|
.gif "ms219346.pubproperty(zh-tw,SQL.90).gif") |
Count | Gets the number of objects in the referenced collection. (inherited from SmoCollectionBase) |
|
IsSynchronized | Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (inherited from SmoCollectionBase) |
|
Item | Overloaded. Gets a Column object in the collection by name or by index number. |
|
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. (inherited from SmoCollectionBase) |
頂端
Public Methods
(see also Protected Methods )
| 名稱 | Description | |
|---|---|---|
.gif "ms219346.pubmethod(zh-tw,SQL.90).gif") |
Add | Overloaded. Adds a Column object to the ColumnCollection collection. |
|
Contains | (inherited from ParameterCollectionBase ) |
|
CopyTo | Copies the collection objects to a one-dimensional array beginning at the index value specified. |
|
Equals | Overloaded. (inherited from Object ) |
|
GetEnumerator | Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (inherited from SmoCollectionBase) |
|
GetHashCode | (inherited from Object ) |
|
GetType | (inherited from Object ) |
|
ItemById | Extracts a member from the ColumnCollection collection using a system-defined, unique identifier. |
.gif "ms219346.static(zh-tw,SQL.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
Refresh | Overloaded. Refreshes the referenced collection. (inherited from SmoCollectionBase) |
|
Remove | Overloaded. Removes a Column object from the ColumnCollection collection. |
|
ToString | (inherited from Object ) |
頂端
Protected Methods
| 名稱 | Description | |
|---|---|---|
.gif "ms219346.protmethod(zh-tw,SQL.90).gif") |
AddExisting | (inherited from AbstractCollectionBase ) |
|
AddImpl | (inherited from ArrayListCollectionBase ) |
|
Finalize | (inherited from Object ) |
|
GetCollectionElementType | Returns the type of object that the collection consists of. (inherited from SmoCollectionBase) |
|
GetItemById | Overloaded. (inherited from SmoCollectionBase ) |
|
GetObjectByIndex | (inherited from SmoCollectionBase ) |
|
ImplAddExisting | (inherited from ParameterCollectionBase ) |
|
InitializeChildCollection | Overloaded. Initializes the child collections of the referenced collection. (inherited from SmoCollectionBase) |
|
InitInnerCollection | Initializes the collection. (inherited from ParameterCollectionBase) |
|
MemberwiseClone | (inherited from Object ) |
|
ValidateParentObject | (inherited from SmoCollectionBase ) |
頂端
Explicit Interface Implementations
| 名稱 | Description | |
|---|---|---|
| System.Collections.ICollection.CopyTo | (inherited from SmoCollectionBase ) |
頂端
請參閱
參考
ColumnCollection Class
Microsoft.SqlServer.Management.Smo Namespace