EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Setting field identity


The Identity tab is only available for integer field types and for user-defined types based on integer types. Using this tab you can create an identity column.

 

CheckBox Identity

This option specifies that the new column is an identity column.

 

Seed

Specify the value used for the first row that is loaded into the table.

 

Increment

Specify the value added to the identity value of the previous row that is loaded.

 

Field Editor - Setting field identity

 

 

CheckBox Not for replication

This option allows you to specify that the Identity property should not be enabled when a replication agent modifies the table that contains the identity column.

 

 

NB: This operation is performed by dropping/recreating the table.