Identity field is usually used as a primary key. when you insert a new record into your table, this field automatically assign an incremented value from the previous entry. ex: create table customer ( ...