Stay informed about any major changes. Click here to subscribe
Autonumbering and identifier columns
For each table, a single identifier column can be created that contains
system-generated sequential values that uniquely identify each row within
the table. Identifier columns usually contain values unique within the
table on which they are defined. This means that other tables containing
identifier columns can contain the same identity values used by another
table. However, this is usually not a problem because the identifier values
are typically used
only within the context of a single table, and the identifier columns
do not relate to other identifier columns in other tables.