Beware of incremental database Ids

Back in school when we were learning database fundamentals, we learned about keywords to build a database table. Known as data definition language. One thing that stood out to me was the IDENTITY column. It allows columns to auto generate an integer each time a new record is inserted. For Microsoft’s Transact-SQL it looks like this: IDENTITY(0,1) This takes two arguments. The first is the seed, meaning the starting value, and second is the increment amount....

December 21, 2021 · 5 min · Hubert Lin