Column.IdentityIncrement Property

Gets or sets the identity increment for an identity column.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property IdentityIncrement As Long 
    Get 
    Set
'Usage
Dim instance As Column 
Dim value As Long 

value = instance.IdentityIncrement

instance.IdentityIncrement = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public long IdentityIncrement { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property long long IdentityIncrement {
    long long get ();
    void set (long long value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member IdentityIncrement : int64 with get, set
function get IdentityIncrement () : long 
function set IdentityIncrement (value : long)

Property Value

Type: System.Int64
An Int32 value that specifies the identity increment.

Remarks

The identity increment is the amount that the identity column increases for each new row.

The Identity property must be set to True before setting this property.

Examples

Working with Database Objects

See Also

Reference

Column Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE TABLE (Transact-SQL)