What is the best way to design a table with an arbitrary id?
- by P.Brian.Mackey
I have the need to create a table with a unique id as the PK. The ID is a surrogate key. Originally, I had a natural key, but requirement changes have undermined this idea. Then, I considered adding an auto incrementing identity. But, this presents problems.
A. I can't specify my own ID.
B. The ID's are difficult to reset.
Both of these…