Choose your SQL server:
AnySQL
MySQL
MS SQL Server
PostgreSQL
Oracle
SQL Anywhere
DB2
SQLite
Firebird
MaxDB

Subscribe to our newsletter

MS SQL Maestro online Help

Prev  Return to chapter overview Next 

Setting field identity

Check the Identity option to indicate that the new column is an identity column.

 

Seed

Defines the value used for the very first row loaded into the table.

 

Increment

Defines the incremental value added to the identity value of the previous row loaded.

 

Not For Replication

If checked, values are not incremented in identity columns when replication agents perform inserts.

 



Prev  Return to chapter overview Next