I’m currently working in a project with a legacy database. The database use a convention, where every table has his own identifier (one-column) and it must be generated by a sequence. The name of the sequence follows a convention, first 26 characters of the Table name + the subfix “seq”...
(Disclaimer: This post will be more or less a paraphrase of Fabio Maulo’s post , and I hope I can improve it a bit) This topic is something that I wanted to write because I wasn’t aware of the drawbacks of “ native/identity ” generator has unt il Fabio told me. Now it is my turn...