ALTER SEQUENCE changes the parameters of an existing sequence generator. Any parameter not specifically set in the ALTER SEQUENCE command retains its prior setting. The clause INCREMENT BY increment ...

Creates a sequence object and specifies its properties. A sequence is a user-defined schema bound object that generates a sequence of numeric values according to the specification with which the ...

However, having the sequence restart at 1 for each unique value of A (a new UPC) allows us to store F in a smallint, which saves us almost 10% of space per observation over forcing F to be unique.