Custom Sequence

[Kumar_27]

Hi Team,

Anyone help to clarify what is use of 'auto_XXXXX_XXXX_seq' is where I am finding this sequence in ACC? if provide a hands-on example it's very helpful to understand. @ParthaSarathy 

[DavidKangni · Accepted solution]

@Kumar_27 

auto sequence were added to ACC to avoid OOTB sequence exhaustion when using autopk in schema.

It's allowing tables to have their own sequence and not use xtkID used by delivery logs tracking logs etc.

It was introduced because customers with big data volume were having issue with data retention in ACC.

Thanks,

David

[Kumar_27]

hi @DavidKangni ,

Thanks for your reply. Could you please explain a bit more?

1) How I am creating a new auto sequence in ACC?

2)  where is this sequence stored in ACC? If possible to view the older Sequence?

[Amine_Abedour]

Hello @Kumar_27,

The a custom sequence is created automaticaly for custom schema if you make the id of the schema an autopk : 

you can find the sequence name in the preview tab of schema form : 

In the database (if it's PostgreSQL), it will create a sequence object stored here and used for each insertion in your schema to retrieve new IDs :

I hope it's clearer for you.

Br,

Amine