What is an auto incremented key?

An auto-incremented key is a key (often used in a parent/foreign key constraint) that is generated automatically by a sequence number generator. The database provides the sequence generator, and generation/acquisition is wrapped in a transaction so that integrity can be preserved. Often, however, if a rollback is done, key values are lost, but this is not an issue in properly designed parent/foreign key relationships.