Useful to set one of the columns as the primary key. To make the primary key an auto generated number create the column as type 'int' then in its properties : Identity Specification = Yes Identity Increment = 1 Identity Seed = 1