The max value for a serial columns is 2147483647. If your serial value
will reach this limit it will go again to 1.
Best Regards,
Octav
On Sat, Mar 20, 1999 at 11:18:56AM -0500, Yan Zhu wrote:
> hi all:
> If I use the autonumber as a key, exactly how far does it go? What's
> the upper limit for a autonumber index?
> What if I have 1 million record and continously adding to it? Also, I
> realize that if you delete a record, it won't use the same autonumber to
> number the next record, so it won't help if I delete the previous
> records? bascially, I am afraid that one day I'll find out I can't add
> any more records because of that.
>
> thanks
>
> yan
>
>
--
Octav Chiriac Phone: (373) 2 21 20 96
NetInfo S.R.L. Fax: (373) 2 21 36 59
Chisinau (373) 2 24 00 83
Moldova, Republic of mailto:com@netinfo-moldova.com