How to use IDENTITY columns in a table. An IDENTITY field is very similar to an auto-number field, where the number will automatically be added as each record is inserted.