What is a sequence (or AUTO_INCREMENT) used for in database design?

Advanced SQL Developer Easy

Advanced SQL Developer — Easy

What is a sequence (or AUTO_INCREMENT) used for in database design?

Key points

  • Sequences are specifically used for generating unique primary key values
  • They do not enforce referential integrity between tables
  • Sequences do not define the sort order of rows in a table

Ready to go further?

Related questions