Sequence Properties

Sequence Properties

 

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyCacheSize

Gets or sets the number of sequence values to be cached.

System_CAPS_pubpropertyCreateDate

Gets a DateTime representing the date and time when the sequence was created.

System_CAPS_pubpropertyCurrentValue

Gets the Object which represents the current value of the Sequence

System_CAPS_pubpropertyDataType

Gets or sets the Microsoft.SqlServer.Management.Smo.DataType of this sequence.

System_CAPS_pubpropertyDateLastModified

Get the DateTime representing the date and time the sequence was last modified.

System_CAPS_pubpropertyEvents

Gets the SequenceEvents object associated with this sequence.

System_CAPS_pubpropertyExtendedProperties

Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property for the ExtendedPropertyCollection object.

System_CAPS_pubpropertyID

Gets the ID value that uniquely identifies the sequence.

System_CAPS_pubpropertyIncrementValue

Gets or sets the object that represents the increment value for the sequence.

System_CAPS_pubpropertyIsCycleEnabled

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.

System_CAPS_pubpropertyIsExhausted

Gets a Boolean which indicates whether the sequence is exhausted.

System_CAPS_pubpropertyIsSchemaOwned

Gets a Boolean value that indicates whether the Sequence object is owned by a schema.

System_CAPS_pubpropertyMaxValue

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.

System_CAPS_pubpropertyMinValue

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.

System_CAPS_pubpropertyName

Gets or sets the name of the sequence.(Overrides ScriptSchemaObjectBase.Name.)

System_CAPS_pubpropertyOwner

Gets the name of the owner of the Sequence object.

System_CAPS_pubpropertyParent

Gets the Database object that is the parent of the Sequence object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertySchema

Gets or sets a String which contains the name of the schema which owns the Sequence.(Overrides ScriptSchemaObjectBase.Schema.)

System_CAPS_pubpropertySequenceCacheType

Gets or sets a SequenceCacheType which indicates how the sequence is cached.

System_CAPS_pubpropertyStartValue

Gets or sets a Object which represents the starting value of the sequence.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

Return to top
Show:
© 2016 Microsoft