Is there an ANSI standard for auto-numbered columns.
Currently, we have a choice of SERIAL
, AUTOINCREMENT
, AUTO_INCREMENT
, 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.