- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi David Thanks for the response. Yes you are right, I am trying to create a custom sequence for one of the table. The reason for custom sequence is xtkNewId had reached its limit and started with negative values. I have found the above code for creating the custom sequence. So as per your suggestion if I insert the record into xtkNewid will it generate sequence unique primary key (same as xtkNewId)?
- Also would like to know, what will be the impact for the existing primary key in the table. Let's say I have a table called XYZ and its Primary key is AB (autopk = true). Now, if I go for the custom sequence will there be any impact for the existing AB records?
Views
Replies
0 Likes
Total Likes