Koen Verbeeck (4/17/2012)
Carlo Romagnano (4/17/2012)
I am curious to know how many developpers will use default value for "START WITH". In most cases will be a negative number.They will all be negative, except for tinyint.
In most cases this shouldn't be a problem, unless you are using the sequence for generating surrogate keys and you have tied special meaning to some of them.
For example: 0 equals unknown, -1 equals not applicable.
A number is a number, it doesn't matter if it is negative or positive,
but when you do maintanance on table or you should copy and paste values to/from excel, great numbers
are annoying.