how can we change xtknewid sequence to custom dedicated sequence on custom schema | Community
Skip to main content
S
Shruti1
Level 4
April 8, 2024
Solved

how can we change xtknewid sequence to custom dedicated sequence on custom schema

  • April 8, 2024
  • 1 reply
  • 586 views

HI all,

@Parvesh_Parmar ,@AkshayAnand 

,@isahore ,@AndreaBriceno,@ParthaSarathy

 

we observed that 

 

xtknewid sequence is being used in our on custom schema

please let me know....

how to change xtknewid sequence to custom dedicated sequence on custom schema

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by isahore

Hi @shruti1,

 

You can do so by updating the same of the sequence to be used in the main element of your schema.

Change pkSequence="XtkNewId" to pkSequence="<<your_custom_sequence_name>>".

 

However, you need to be careful while doing this on an existing schema. If your schema already has data and links to other tables using the auto-generated keys previously, doing this without due diligence might lead you into more issues. If it is so, then you should do an impact analysis and make a data strategy for doing this update on that schema.

 

For empty schemas, this should be a straightforward activity.

For new schemas, since last many builds, a custom sequence is automatically generated and used, unless some other settings override this feature.

 

BR,

Ishan

1 reply

isahore
Community Advisor
isahoreCommunity AdvisorAccepted solution
Community Advisor
April 8, 2024

Hi @shruti1,

 

You can do so by updating the same of the sequence to be used in the main element of your schema.

Change pkSequence="XtkNewId" to pkSequence="<<your_custom_sequence_name>>".

 

However, you need to be careful while doing this on an existing schema. If your schema already has data and links to other tables using the auto-generated keys previously, doing this without due diligence might lead you into more issues. If it is so, then you should do an impact analysis and make a data strategy for doing this update on that schema.

 

For empty schemas, this should be a straightforward activity.

For new schemas, since last many builds, a custom sequence is automatically generated and used, unless some other settings override this feature.

 

BR,

Ishan

    Terms & ConditionsAccessibility statement

    Loading footer...