sequence verification
Hi,
I've perused the forums for the last half hour and haven't found exactly what I am looking for.
I was looking to select * from user_source where type = 'sequence' to see what all sequences I have in my account without selecting every single thing.
Is there a command for that?
Further, my sequence in my development environment -- after having topped out at #2481, started repeating to 1. As in #1.
So a quick glimpse in the DB table reveals two records with the primary ID as #1 in both tables that receive inserts simultaneously.
Any idea why that would have happened? Why it would start repeating indiscriminantly like that? That befuddles me a bit.
But anyone that can enlighten me on this, I welcome the feedback.
Or instruct me how I need to go about changing this!
Thanks!