SequenceCollection Class
The SequenceCollection class represents a collection of Sequence objects that represent all the Sequences on the referenced database.
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.Management.Smo.AbstractCollectionBase
Microsoft.SqlServer.Management.Smo.SmoCollectionBase
Microsoft.SqlServer.Management.Smo.SortedListCollectionBase
Microsoft.SqlServer.Management.Smo.SchemaCollectionBase
Microsoft.SqlServer.Management.Smo.SequenceCollection
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public NotInheritable Class SequenceCollection _
Inherits SchemaCollectionBase
'Usage
Dim instance As SequenceCollection
public sealed class SequenceCollection : SchemaCollectionBase
public ref class SequenceCollection sealed : public SchemaCollectionBase
[<SealedAttribute>]
type SequenceCollection =
class
inherit SchemaCollectionBase
end
public final class SequenceCollection extends SchemaCollectionBase
The SequenceCollection type exposes the following members.
Properties
Name | Description | |
---|---|---|
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[Int32] | Gets a Sequence object in the collection by index number. | |
Item[String] | Gets a Sequence object in the collection by name. | |
Item[String, String] | Gets a Sequence object in the collection by name and Schema. | |
Parent | Gets the Database object that is the parent of the SequenceCollection object. | |
SyncRoot | Gets an object that can be used to synchronize access to the collection. (Inherited from SmoCollectionBase.) |
Top
Methods
Name | Description | |
---|---|---|
Add | Adds a member to the SequenceCollection collection | |
AddExisting | Adds an object to the collection. (Inherited from AbstractCollectionBase.) | |
Contains(String) | Validates whether the parameter collection contains a member with a name equal to the specified string. (Inherited from SchemaCollectionBase.) | |
Contains(String, String) | Validates whether the parameter collection contains a member with a name equal to the specified string and with the specified schema. (Inherited from SchemaCollectionBase.) | |
CopyTo | Copies the collection of objects to a one-dimensional array beginning at the index value specified. | |
Equals | (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 SequenceCollection collection using a system-defined, unique identifier. | |
Refresh() | Refreshes the referenced collection. (Inherited from SmoCollectionBase.) | |
Refresh(Boolean) | Refreshes the referenced collection with the option to refresh child objects of the referenced collection. (Inherited from SmoCollectionBase.) | |
ToString | (Inherited from Object.) |
Top
Fields
Name | Description | |
---|---|---|
initialized | This value supports the SMO infrastructure and is not intended to be used directly from your code. (Inherited from AbstractCollectionBase.) |
Top
Explicit Interface Implementations
Name | Description | |
---|---|---|
ICollection.CopyTo | Copies the elements from an instance to an array beginning at the index indicated. (Inherited from SmoCollectionBase.) |
Top
Remarks
A SequenceCollection object can be used to gain access to a set of Sequences. You can use the Item property to return a specific Sequence object.
Examples
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.