Dela via

  • Artikel

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.