Export (0) Print
Expand All

Sequence Properties

The Sequence type exposes the following members.

  Name Description
Public property CacheSize Gets or sets the number of sequence values to be cached.
Public property CreateDate Gets a DateTime representing the date and time when the sequence was created.
Public property CurrentValue Gets the Object which represents the current value of the Sequence
Public property DataType Gets or sets the [Microsoft.SqlServer.Management.Smo.DataType] of this sequence.
Public property DateLastModified Get the DateTime representing the date and time the sequence was last modified.
Public property Events Gets the SequenceEvents object associated with this sequence.
Public property ExtendedProperties Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property for the ExtendedPropertyCollection object.
Public property ID Gets the ID value that uniquely identifies the sequence.
Public property IncrementValue Gets or sets the object that represents the increment value for the sequence.
Public property IsCycleEnabled Gets or sets a Boolean that specifies whether the sequence object should restart from the minimum value (or maximum for descending sequence objects) or throw an exception when its minimum or maximum value is exceeded.
Public property IsExhausted Gets a Boolean which indicates whether the sequence is exhausted.
Public property IsSchemaOwned Gets a Boolean value that indicates whether the Sequence object is owned by a schema.
Public property MaxValue Gets or sets an Object that specifies the upper bound for the sequence object. The default maximum value for a new sequence object is the maximum value of the data type of the sequence object.
Public property MinValue Gets or sets an Object that specifies the lower bound for the sequence object. The default minimum value for a new sequence object is the minimum value of the data type of the sequence object.
Public property Name Gets or sets the name of the sequence. (Overrides ScriptSchemaObjectBase.Name.)
Public property Owner Gets the name of the owner of the Sequence object.
Public property Parent Gets the Database object that is the parent of the Sequence object.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property Schema Gets or sets a String which contains the name of the schema which owns the Sequence. (Overrides ScriptSchemaObjectBase.Schema.)
Public property SequenceCacheType Gets or sets a SequenceCacheType which indicates how the sequence is cached.
Public property StartValue Gets or sets a Object which represents the starting value of the sequence.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top

Community Additions

ADD
Show:
© 2014 Microsoft