Is there an ANSI standard for auto-numbered columns.
Currently, we have a choice of
IDENTITY() and good old
NEXTVAL() among others.
I read somewhere that there is a new standard using
IDENTITY which I know that Oracle has recently implemented. I know that Oracle is hardly the last word on standards.
If there is a standard, then it’s a long time coming.