Brett Wooldridge <[email protected]> writes: > We are currently using Hibernate with a table managed sequence scheme > (javax.persistence.GenerationType.TABLE), but now that Derby supports > Sequences we are considering migrating to real sequences > (javax.persistence.GenerationType.SEQUENCE). > > One question we have is, is it possible to ALTER a sequence? From > what I've seen, the answer is currently no, but I thought I would ask > here just in case.
It is not supported. You would have to do a DROP + a new CREATE. Note that a new sequence can take a START WITH value, though. Thanks, Dag
