Table of Contents

Property IdentityStartValue

Namespace
YndigoBlue.Velocity.Data.Teradata
Assembly
YndigoBlue.Velocity.dll

IdentityStartValue

Gets or sets the starting value for identity columns.

public long IdentityStartValue { get; set; }

Property Value

long

Remarks

This setting controls the initial value assigned to auto-incrementing identity columns when they are first created. The default value of 1 means the first row inserted will have an identity value of 1, the second row will have 2, and so on.

Use Cases:

  • Standard (Start at 1): Appropriate for new tables where you want sequencing to begin from 1.
  • Large Starting Values (e.g., 1000000): When migrating data from another system that uses high identity values, set this to avoid collisions with existing data.
  • Non-Sequential (e.g., 10, 100, 1000): For specific business logic (e.g., invoice numbers, order IDs) that require non-sequential numbering or skip values.

Important: This value is applied when the schema is built or the table is created. Changing it after table creation does not affect existing identity sequences; it only affects newly created tables.