Sequence types compared

The following table lists the differences between the two sequence types:.

The following table lists the differences between the two sequence types:

Supported Behavior	Named Sequence	AUTO_INCREMENT/IDENTITY
Default cache value 250K	•	•
Set initial cache	•	•
Define start value	•	•
Specify increment unit	•	•
Exists as an independent object	•
Exists only as part of table		•
Create as column constraint		•
Requires name	•
Use in expressions	•
Unique across tables	•
Change parameters	•
Move to different schema	•
Set to increment or decrement	•
Grant privileges to object	•
Specify minimum value	•
Specify maximum value	•