DB2: Sequences Cheat Sheet

Creating a sequence

db2 create sequence <seq_name> 

Viewing the sequences

db2 value <previous/next> value for <seq_name>

Dropping the sequence

db2 drop sequence <seq_name>>

Leave a Reply

Your email address will not be published. Required fields are marked *