Although the IDENTITY property automates row numbering within one table, separate tables, each with its own identifier column, can generate the same values.