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

  Name Description
ms219346.protfield(en-US,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)

Top

Public Properties

  Name Description
ms219346.pubproperty(en-US,SQL.90).gif Count  Gets the number of objects in the referenced collection. (inherited from SmoCollectionBase)
ms219346.pubproperty(en-US,SQL.90).gif IsSynchronized  Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (inherited from SmoCollectionBase)
ms219346.pubproperty(en-US,SQL.90).gif Item Overloaded. Gets a Column object in the collection by name or by index number.
ms219346.pubproperty(en-US,SQL.90).gif Parent Gets the SqlSmoObject object that is the parent of the ColumnCollection object.
ms219346.pubproperty(en-US,SQL.90).gif SyncRoot  Gets an object that can be used to synchronize access to the collection. (inherited from SmoCollectionBase)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms219346.pubmethod(en-US,SQL.90).gif Add Overloaded. Adds a Column object to the ColumnCollection collection.
ms219346.pubmethod(en-US,SQL.90).gif Contains  (inherited from ParameterCollectionBase )
ms219346.pubmethod(en-US,SQL.90).gif CopyTo Copies the collection objects to a one-dimensional array beginning at the index value specified.
ms219346.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219346.pubmethod(en-US,SQL.90).gif GetEnumerator  Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (inherited from SmoCollectionBase)
ms219346.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms219346.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219346.pubmethod(en-US,SQL.90).gif ItemById Extracts a member from the ColumnCollection collection using a system-defined, unique identifier.
ms219346.pubmethod(en-US,SQL.90).gifms219346.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219346.pubmethod(en-US,SQL.90).gif Refresh  Overloaded. Refreshes the referenced collection. (inherited from SmoCollectionBase)
ms219346.pubmethod(en-US,SQL.90).gif Remove Overloaded. Removes a Column object from the ColumnCollection collection.
ms219346.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )

Top

Protected Methods

  Name Description
ms219346.protmethod(en-US,SQL.90).gif AddExisting  (inherited from AbstractCollectionBase )
ms219346.protmethod(en-US,SQL.90).gif AddImpl  (inherited from ArrayListCollectionBase )
ms219346.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms219346.protmethod(en-US,SQL.90).gif GetCollectionElementType  Returns the type of object that the collection consists of. (inherited from SmoCollectionBase)
ms219346.protmethod(en-US,SQL.90).gif GetItemById  Overloaded. (inherited from SmoCollectionBase )
ms219346.protmethod(en-US,SQL.90).gif GetObjectByIndex  (inherited from SmoCollectionBase )
ms219346.protmethod(en-US,SQL.90).gif ImplAddExisting  (inherited from ParameterCollectionBase )
ms219346.protmethod(en-US,SQL.90).gif InitializeChildCollection  Overloaded. Initializes the child collections of the referenced collection. (inherited from SmoCollectionBase)
ms219346.protmethod(en-US,SQL.90).gif InitInnerCollection  Initializes the collection. (inherited from ParameterCollectionBase)
ms219346.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )
ms219346.protmethod(en-US,SQL.90).gif ValidateParentObject  (inherited from SmoCollectionBase )

Top

Explicit Interface Implementations

  Name Description
System.Collections.ICollection.CopyTo  (inherited from SmoCollectionBase )

Top

See Also

Reference

ColumnCollection Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Using Collections