Question How can I get from _sequence to _file as the _seq-name does not do it

Dave Grandon

New Member
I am trying to write a routine to update all sequences when bulk data is copied to a testing system but cannot find the link to the relevant file.


Any link between sequences and tables is application specific. Sequences are not specifically linked to tables or fields and can be used for many purposes across an arbitrary number of tables or even no tables at all. So you need to either review the documentation for the application or dig into the code to understand any such relationships.

On the other hand… maybe you’re approaching this backwards. Why wouldn’t you simply dump the sequence current values from the source and load them into the target?